<html>
<head>
  <title>07-B+树索引的使用</title>
  <basefont face="微软雅黑" size="2" />
  <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
  <meta name="exporter-version" content="YXBJ Windows/600646 (zh-CN, DDL); Windows/6.1.1 (Win64);"/>
  <meta name="content-class" content="yinxiang.markdown"/>
  <style>
    body, td {
      font-family: 微软雅黑;
      font-size: 10pt;
    }
  </style>
</head>
<body>
<a name="677"/>
<h1>07-B+树索引的使用</h1>

<div><span><div style="font-size: 14px; margin: 0; padding: 0; width: 100%;"><h2 style="line-height: 160%; box-sizing: content-box; font-weight: 700; font-size: 34px; border-bottom: 1px solid #dbdbdb; color: #333;">1. 索引的代价</h2>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">空间上的代价</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">这个是显而易见的，每建立一个索引都要为它建立一棵B+树，每一棵B+树的每一个节点都是一个数据页，一个页默认会占用16KB的存储空间，一棵很大的B+树由许多数据页组成，那可是很大的一片存储空间。</p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">时间上的代价</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">每次对表中的数据进行增、删、改操作时，都需要去修改各个B+树索引。而且我们讲过，B+树每层节点都是按照索引列的值从小到大的顺序排序而组成了双向链表。不论是叶子节点中的记录，还是内节点中的记录（也就是不论是用户记录还是目录项记录）都是按照索引列的值从小到大的顺序而形成了一个单向链表。而增、删、改操作可能会对节点和记录的排序造成破坏，所以存储引擎需要额外的时间进行一些记录移位，页面分裂、页面回收啥的操作来维护好节点和记录的排序。</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">所以说，一个表上索引建的越多，就会占用越多的存储空间，在增删改记录的时候性能就越差。</p>
<h2 style="line-height: 160%; box-sizing: content-box; font-weight: 700; font-size: 34px; border-bottom: 1px solid #dbdbdb; color: #333;">2. B+树索引的适用条件</h2>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">先创建一个示例表：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">CREATE TABLE person_info(<br/>
id INT NOT NULL auto_increment,<br/>
name VARCHAR(100) NOT NULL,<br/>
birthday DATE NOT NULL,<br/>
phone_number CHAR(11) NOT NULL,<br/>
country varchar(100) NOT NULL,<br/>
PRIMARY KEY (id),<br/>
KEY idx_name_birthday_phone_number (name, birthday, phone_number)<br/>
);</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">person_info表会为聚簇索引和idx_name_birthday_phone_number索引建立2棵B+树。idx_name_birthday_phone_number的B+树中<br/>
在记录结构中只保留name、birthday、phone_number、id这四个列的真实数据值，示意图如下：<br/>
<img src="07-B+树索引的使用_files/1.jpg" type="image/jpeg" data-filename="1.jpg"/></p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">从图中可以看出，这个idx_name_birthday_phone_number索引对应的B+树中页面和记录的排序方式就是这样的：</p>
<ul style="line-height: 160%; box-sizing: content-box; display: block; list-style-type: disc; padding-left: 30px; margin: 6px 0 10px; color: #333;">
<li style="line-height: 160%; box-sizing: content-box; position: relative;">先按照name列的值进行排序；</li>
<li style="line-height: 160%; box-sizing: content-box; position: relative;">如果name列的值相同，则按照birthday列的值进行排序；</li>
<li style="line-height: 160%; box-sizing: content-box; position: relative;">如果birthday列的值也相同，则按照phone_number的值进行排序；</li>
</ul>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">这个排序方式十分、特别、非常、巨、very very very重要，因为只要页面和记录是排好序的，就可以通过二分法来快速定位查找。</p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">全值匹配</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">如果我们的搜索条件中的列和索引列一致的话，这种情况就称为全值匹配，比方说下边这个查找语句：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">SELECT * FROM person_info WHERE name = 'Ashburn' AND birthday = '1990-09-27' AND phone_number = '15123983239';</strong></p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">最左前缀匹配</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">如果想使用联合索引中尽可能多的列，搜索条件中的各个列必须是联合索引中从最左边连续的列。</strong></p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">那为什么搜索条件中必须出现左边的列才可以使用到这个B+树索引呢？比如下边的语句就用不到这个B+树索引：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">SELECT * FROM person_info WHERE birthday = '1990-09-27';</strong></p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">因为B+树的数据页和记录先是按照name列的值排序的，在name列的值相同的情况下才使用birthday列进行排序，也就是说name列的值不同的记录中birthday的值可能是无序的。</p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">匹配列前缀</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">在某字符串上的列建立索引时，这些字符串的前n个字符，也就是前缀都是排好序的，所以对于字符串类型的索引列来说，我们只匹配它的前缀也是可以快速定位记录的，比方说我们想查询名字以'As'开头的记录，那就可以这么写查询语句：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">SELECT * FROM person_info WHERE name LIKE 'As%'；</strong><br/>
注意这里的LIKE是最左端精确匹配。</p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">匹配范围值</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">idx_name_birthday_phone_number索引的B+树示意图，所有记录都是按照索引列的值从小到大的顺序排好序的，所以这极大的方便我们查找索引列的值在某个范围内的记录。比方说下边这个查询语句：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">SELECT * FROM person_info WHERE name &gt; 'Asa' AND name &lt; 'Barlow'；</strong></p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">不过在使用联合进行范围查找的时候需要注意，如果对多个列同时进行范围查找的话，只有对索引最左边的那个列进行范围查找的时候才能用到B+树索引，比方说这样：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">SELECT * FROM person_info WHERE name &gt; 'Asa' AND name &lt; 'Barlow' AND birthday &gt; '1980-01-01'；</strong></p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">这样子对于联合索引idx_name_birthday_phone_number来说，只能用到name列的部分，而用不到birthday列的部分，因为只有name值相同的情况下才能用birthday列的值进行排序，而这个查询中通过name进行范围查找的记录中可能并不是按照birthday列进行排序的，所以在搜索条件中继续以birthday列进行查找时是用不到这个B+树索引的。</p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">精确匹配某一列并范围匹配另外一列</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">对于同一个联合索引来说，虽然对多个列都进行范围查找时只能用到最左边那个索引列，但是如果左边的列是精确查找，则右边的列可以进行范围查找，比方说这样：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">SELECT * FROM person_info WHERE name = 'Ashburn' AND birthday = '1980-01-01' AND AND phone_number &gt; '15100000000'；</strong></p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">用于排序</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">在写查询语句的时候经常需要对查询出来的记录通过ORDER BY子句按照某种规则进行排序。一般情况下，我们只能把记录都加载到内存中，再用一些排序算法，比如快速排序、归并排序、吧啦吧啦排序等等在内存中对这些记录进行排序，有的时候可能查询的结果集太大以至于不能在内存中进行排序的话，还可能暂时借助磁盘的空间来存放中间结果，排序操作完成后再把排好序的结果集返回到客户端。在MySQL中，把这种<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">在内存中或者磁盘上进行排序的方式统称为文件排序（英文名：filesort）</strong>，跟文件这个词儿一沾边儿，就显得这些排序操作非常慢了（磁盘和内存的速度比起来，就像是飞机和蜗牛的对比）。但是如果ORDER BY子句里使用到了我们的索引列，就有可能省去在内存或文件中排序的步骤，比如下边这个简单的查询语句：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">SELECT * FROM person_info ORDER BY name, birthday, phone_number LIMIT 10；</strong></p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">使用联合索引进行排序注意事项</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">对于联合索引有个问题需要注意，ORDER BY的子句后边的列的顺序也必须按照索引列的顺序给出，如果给出ORDER BY phone_number, birthday, name的顺序，那也是用不了B+树索引。</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">同理，ORDER BY name、ORDER BY name, birthday这种匹配索引左边的列的形式可以使用部分的B+树索引。当联合索引左边列的值为常量，也可以使用后边的列进行排序，比如这样：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">SELECT * FROM person_info WHERE name = 'A' ORDER BY birthday, phone_number LIMIT 10；</strong></p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">不可以使用索引进行排序的几种情况</h4>
<ol style="line-height: 160%; box-sizing: content-box; display: block; padding-left: 30px; margin: 6px 0 10px; color: #333; list-style-type: decimal;">
<li style="line-height: 160%; box-sizing: content-box;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">ASC、DESC混用</strong>，如：SELECT * FROM person_info ORDER BY name, birthday DESC LIMIT 10；</li>
<li style="line-height: 160%; box-sizing: content-box;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">WHERE子句中出现非排序使用到的索引列</strong>，如：SELECT * FROM person_info WHERE country = 'China' ORDER BY name LIMIT 10；</li>
<li style="line-height: 160%; box-sizing: content-box;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">排序列包含非同一个索引的列</strong>，如：SELECT * FROM person_info ORDER BY name, country LIMIT 10；</li>
<li style="line-height: 160%; box-sizing: content-box;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">排序列使用了复杂的表达式</strong>，如：SELECT * FROM person_info ORDER BY UPPER(name) LIMIT 10；</li>
</ol>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">用于分组</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">使用B+树索引进行排序是一个道理，分组列的顺序也需要和索引列的顺序一致，也可以只使用索引列中左边的列进行分组；</p>
<h3 style="line-height: 160%; box-sizing: content-box; font-weight: 700; font-size: 27px; color: #333;">其他几种特殊的索引失效的情况</h3>
<ol style="line-height: 160%; box-sizing: content-box; display: block; padding-left: 30px; margin: 6px 0 10px; color: #333; list-style-type: decimal;">
<li style="line-height: 160%; box-sizing: content-box;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">在对字符串字段使用索引时，需要注意一种特殊情况：数据类型的隐式转换，这种情况会导致索引失效。</strong></li>
<li style="line-height: 160%; box-sizing: content-box;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">在使用Limit分页时，如果数据量很大，可能会导致索引失效（这种情况需要好好研究一下，暂时还没有确定）</strong></li>
</ol>
<h2 style="line-height: 160%; box-sizing: content-box; font-weight: 700; font-size: 34px; border-bottom: 1px solid #dbdbdb; color: #333;">3. 回表的代价</h2>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">上边的讨论对回表这个词儿多是一带而过，可能大家没啥深刻的体会，下边我们详细唠叨下。还是用idx_name_birthday_phone_number索引为例，看下边这个查询：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">SELECT * FROM person_info WHERE name &gt; 'Asa' AND name &lt; 'Barlow';</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">在使用idx_name_birthday_phone_number索引进行查询时大致可以分为这两个步骤：</p>
<ol style="line-height: 160%; box-sizing: content-box; display: block; padding-left: 30px; margin: 6px 0 10px; color: #333; list-style-type: decimal;">
<li style="line-height: 160%; box-sizing: content-box;">从索引idx_name_birthday_phone_number对应的B+树中取出name值在Asa～Barlow之间的用户记录；</li>
<li style="line-height: 160%; box-sizing: content-box;">由于索引idx_name_birthday_phone_number对应的B+树用户记录中只包含name、birthday、phone_number、id这4个字段，而查询列表是*，意味着要查询表中所有字段，也就是还要包括country字段。这时需要把从上一步中获取到的每一条记录的id字段都到聚簇索引对应的B+树中找到完整的用户记录，也就是我们通常所说的<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">回表</strong>，然后把完整的用户记录返回给查询用户；</li>
</ol>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">由于索引idx_name_birthday_phone_number对应的B+树中的记录首先会按照name列的值进行排序，所以值在Asa～Barlow之间的记录在磁盘中的存储是相连的，集中分布在一个或几个数据页中，我们可以很快的把这些连着的记录从磁盘中读出来，这种读取方式我们也可以称为<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">顺序I/O</strong>。根据第1步中获取到的记录的id字段的值可能并不相连，而在聚簇索引中记录是根据id（也就是主键）的顺序排列的，所以根据这些并不连续的id值到聚簇索引中访问完整的用户记录可能分布在不同的数据页中，这样读取完整的用户记录可能要访问更多的数据页，这种读取方式我们也可以称为<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">随机I/O</strong>。一般情况下，顺序I/O比随机I/O的性能高很多，所以步骤1的执行可能很快，而步骤2就慢一些。所以这个使用索引idx_name_birthday_phone_number的查询有这么两个特点：</p>
<ul style="line-height: 160%; box-sizing: content-box; display: block; list-style-type: disc; padding-left: 30px; margin: 6px 0 10px; color: #333;">
<li style="line-height: 160%; box-sizing: content-box; position: relative;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">会使用到两个B+树索引，一个二级索引，一个聚簇索引；</strong></li>
<li style="line-height: 160%; box-sizing: content-box; position: relative;"><strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">访问二级索引使用顺序I/O，访问聚簇索引使用随机I/O；</strong></li>
</ul>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">需要回表的记录越多，使用二级索引的性能就越低，甚至让某些查询宁愿使用全表扫描也不使用二级索引。比方说name值在Asa～Barlow之间的用户记录数量占全部记录数量90%以上，那么如果使用idx_name_birthday_phone_number索引的话，有90%多的id值需要回表，这不是吃力不讨好么，还不如直接去扫描聚簇索引（也就是全表扫描）。那什么时候采用全表扫描的方式，什么时候使用采用二级索引 + 回表的方式去执行查询呢？这个就是传说中的查询优化器做的工作，查询优化器会事先对表中的记录计算一些统计数据，然后再利用这些统计数据根据查询的条件来计算一下需要回表的记录数，需要回表的记录数越多，就越倾向于使用全表扫描，反之倾向于使用二级索引 + 回表的方式。当然优化器做的分析工作不仅仅是这么简单，但是大致上是个这个过程。一般情况下，限制查询获取较少的记录数会让优化器更倾向于选择使用二级索引 + 回表的方式进行查询，因为回表的记录越少，性能提升就越高，比方说上边的查询可以改写成这样：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">SELECT * FROM person_info WHERE name &gt; 'Asa' AND name &lt; 'Barlow' LIMIT 10;</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">添加了LIMIT 10的查询更容易让优化器采用二级索引 + 回表的方式进行查询。对于有排序需求的查询，上边讨论的采用全表扫描还是二级索引 + 回表的方式进行查询的条件也是成立的。</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">由于查询列表是*，所以如果使用二级索引进行排序的话，需要把排序完的二级索引记录全部进行回表操作，这样操作的成本还不如直接遍历聚簇索引然后再进行文件排序（filesort）低，所以优化器会倾向于使用全表扫描的方式执行查询。如果我们加了LIMIT子句，比如这样：<br/>
SELECT * FROM person_info ORDER BY name, birthday, phone_number LIMIT 10；<br/>
这样需要回表的记录特别少，优化器就会倾向于使用二级索引 + 回表的方式执行查询。</p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">覆盖索引</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">为了彻底告别回表操作带来的性能损耗，我们建议：最好在查询列表里只包含索引列，比如这样：<br/>
<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">SELECT name, birthday, phone_number FROM person_info WHERE name &gt; 'Asa' AND name &lt; 'Barlow'；</strong></p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">因为我们只查询name, birthday, phone_number这三个索引列的值，所以在通过idx_name_birthday_phone_number索引得到结果后就不必到聚簇索引中再查找记录的剩余列，也就是country列的值了，这样就省去了回表操作带来的性能损耗。我们把这种只需要用到索引的查询方式称为索引覆盖。排序操作也优先使用覆盖索引的方式进行查询，比方说这个查询：<br/>
<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">SELECT name, birthday, phone_number  FROM person_info ORDER BY name, birthday, phone_number；</strong></p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">虽然这个查询中没有LIMIT子句，但是采用了覆盖索引，所以查询优化器就会直接使用idx_name_birthday_phone_number索引进行排序而不需要回表操作了。当然，如果业务需要查询出索引以外的列，那还是以保证业务需求为重。但是我们很不鼓励用*号作为查询列表，最好把我们需要查询的列依次标明。</p>
<h2 style="line-height: 160%; box-sizing: content-box; font-weight: 700; font-size: 34px; border-bottom: 1px solid #dbdbdb; color: #333;">4. 如何挑选索引</h2>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">只为用于搜索、排序或分组的列创建索引</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">只为出现在<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">WHERE子句</strong>中的列、连接子句中的连接列，或者出现在<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">ORDER BY</strong>或<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">GROUP BY</strong>子句中的列创建索引。而出现在查询列表中的列就没必要建立索引了</p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">考虑列的基数</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">列的基数指的是某一列中不重复数据的个数，比方说某个列包含值2, 5, 8, 2, 5, 8, 2, 5, 8，虽然有9条记录，但该列的基数却是3。也就是说，在记录行数一定的情况下，列的基数越大，该列中的值越分散，列的基数越小，该列中的值越集中。这个列的基数指标非常重要，直接影响我们是否能有效的利用索引。假设某个列的基数为1，也就是所有记录在该列中的值都一样，那为该列建立索引是没有用的，因为所有值都一样就无法排序，无法进行快速查找了～ 而且如果某个建立了二级索引的列的重复值特别多，那么使用这个二级索引查出的记录还可能要做回表操作，这样性能损耗就更大了。所以结论就是：最好为那些列的基数大的列建立索引，为基数太小列的建立索引效果可能不好。</p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">索引列的类型尽量小</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">我们在定义表结构的时候要显式的指定列的类型，以整数类型为例，有TINYINT、MEDIUMINT、INT、BIGINT这么几种，它们占用的存储空间依次递增，我们这里所说的类型大小指的就是该类型表示的数据范围的大小。能表示的整数范围当然也是依次递增，如果我们想要对某个整数列建立索引的话，<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">在表示的整数范围允许的情况下，尽量让索引列使用较小的类型</strong>，比如我们能使用INT就不要使用BIGINT，能使用MEDIUMINT就不要使用INT～ 这是因为：</p>
<ul style="line-height: 160%; box-sizing: content-box; display: block; list-style-type: disc; padding-left: 30px; margin: 6px 0 10px; color: #333;">
<li style="line-height: 160%; box-sizing: content-box; position: relative;">数据类型越小，在查询时进行的比较操作越快（这是CPU层次的东东）；</li>
<li style="line-height: 160%; box-sizing: content-box; position: relative;">数据类型越小，索引占用的存储空间就越少，在一个数据页内就可以放下更多的记录，从而减少磁盘I/O带来的性能损耗，也就意味着可以把更多的数据页缓存在内存中，从而加快读写效率；</li>
</ul>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">这个建议对于表的主键来说更加适用，因为不仅是聚簇索引中会存储主键值，其他所有的二级索引的节点处都会存储一份记录的主键值，如果主键适用更小的数据类型，也就意味着节省更多的存储空间和更高效的I/O。</p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">索引字符串值的前缀</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">只对字符串的前几个字符进行索引也就是说在二级索引的记录中只保留字符串前几个字符。这样在查找记录时虽然不能精确的定位到记录的位置，但是能定位到相应前缀所在的位置，然后根据前缀相同的记录的主键值回表查询完整的字符串值，再对比就好了。这样只在B+树中存储字符串的前几个字符的编码，既节约空间，又减少了字符串的比较时间，还大概能解决排序的问题，何乐而不为，比方说我们在建表语句中只对name列的前10个字符进行索引可以这么写：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">CREATE TABLE person_info(<br/>
name VARCHAR(100) NOT NULL,<br/>
birthday DATE NOT NULL,<br/>
phone_number CHAR(11) NOT NULL,<br/>
country varchar(100) NOT NULL,<br/>
<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">KEY idx_name_birthday_phone_number (name(10), birthday, phone_number)</strong><br/>
);</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">name(10)就表示在建立的B+树索引中只保留记录的前10个字符的编码，这种只<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">索引字符串值的前缀的策略是我们非常鼓励的，尤其是在字符串类型能存储的字符比较多的时候</strong>。</p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">索引列前缀对排序的影响</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">如果使用了索引列前缀，比方说前边只把name列的前10个字符放到了二级索引中，下边这个查询可能就有点儿尴尬了：</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">SELECT * FROM person_info ORDER BY name LIMIT 10;</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">因为二级索引中不包含完整的name列信息，所以无法对前十个字符相同，后边的字符不同的记录进行排序，也就是使用索引列前缀的方式无法支持使用索引排序，只好乖乖的用文件排序喽。</p>
<h4 style="line-height: 160%; box-sizing: content-box; font-size: 20px; color: #333;">让索引列在比较表达式中单独出现</h4>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">假设表中有一个整数列my_col，我们为这个列建立了索引。下边的两个WHERE子句虽然语义是一致的，但是在效率上却有差别：</p>
<ol style="line-height: 160%; box-sizing: content-box; display: block; padding-left: 30px; margin: 6px 0 10px; color: #333; list-style-type: decimal;">
<li style="line-height: 160%; box-sizing: content-box;">WHERE my_col * 2 &lt; 4；</li>
<li style="line-height: 160%; box-sizing: content-box;">WHERE my_col &lt; 4/2；</li>
</ol>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">第1个WHERE子句中my_col列并不是以单独列的形式出现的，而是以my_col * 2这样的表达式的形式出现的，存储引擎会依次遍历所有的记录，计算这个表达式的值是不是小于4，所以这种情况下是使用不到为my_col列建立的B+树索引的。而第2个WHERE子句中my_col列并是以单独列的形式出现的，这样的情况可以直接使用B+树索引。</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;">所以结论就是：<strong style="line-height: 160%; box-sizing: content-box; font-weight: 700;">如果索引列在比较表达式中不是以单独列的形式出现，而是以某个表达式，或者函数调用形式出现的话，是用不到索引的</strong>。</p>
<p style="line-height: 160%; box-sizing: content-box; margin: 10px 0; color: #333;"><img src="07-B+树索引的使用_files/1 [1].jpg" type="image/jpeg" data-filename="1.jpg"/></p>
</div><center style="display:none !important;visibility:collapse !important;height:0 !important;white-space:nowrap;width:100%;overflow:hidden">%23%23%201.%20%E7%B4%A2%E5%BC%95%E7%9A%84%E4%BB%A3%E4%BB%B7%0A%0A%23%23%23%23%20%E7%A9%BA%E9%97%B4%E4%B8%8A%E7%9A%84%E4%BB%A3%E4%BB%B7%0A%E8%BF%99%E4%B8%AA%E6%98%AF%E6%98%BE%E8%80%8C%E6%98%93%E8%A7%81%E7%9A%84%EF%BC%8C%E6%AF%8F%E5%BB%BA%E7%AB%8B%E4%B8%80%E4%B8%AA%E7%B4%A2%E5%BC%95%E9%83%BD%E8%A6%81%E4%B8%BA%E5%AE%83%E5%BB%BA%E7%AB%8B%E4%B8%80%E6%A3%B5B%2B%E6%A0%91%EF%BC%8C%E6%AF%8F%E4%B8%80%E6%A3%B5B%2B%E6%A0%91%E7%9A%84%E6%AF%8F%E4%B8%80%E4%B8%AA%E8%8A%82%E7%82%B9%E9%83%BD%E6%98%AF%E4%B8%80%E4%B8%AA%E6%95%B0%E6%8D%AE%E9%A1%B5%EF%BC%8C%E4%B8%80%E4%B8%AA%E9%A1%B5%E9%BB%98%E8%AE%A4%E4%BC%9A%E5%8D%A0%E7%94%A816KB%E7%9A%84%E5%AD%98%E5%82%A8%E7%A9%BA%E9%97%B4%EF%BC%8C%E4%B8%80%E6%A3%B5%E5%BE%88%E5%A4%A7%E7%9A%84B%2B%E6%A0%91%E7%94%B1%E8%AE%B8%E5%A4%9A%E6%95%B0%E6%8D%AE%E9%A1%B5%E7%BB%84%E6%88%90%EF%BC%8C%E9%82%A3%E5%8F%AF%E6%98%AF%E5%BE%88%E5%A4%A7%E7%9A%84%E4%B8%80%E7%89%87%E5%AD%98%E5%82%A8%E7%A9%BA%E9%97%B4%E3%80%82%0A%0A%0A%23%23%23%23%20%E6%97%B6%E9%97%B4%E4%B8%8A%E7%9A%84%E4%BB%A3%E4%BB%B7%0A%0A%E6%AF%8F%E6%AC%A1%E5%AF%B9%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%95%B0%E6%8D%AE%E8%BF%9B%E8%A1%8C%E5%A2%9E%E3%80%81%E5%88%A0%E3%80%81%E6%94%B9%E6%93%8D%E4%BD%9C%E6%97%B6%EF%BC%8C%E9%83%BD%E9%9C%80%E8%A6%81%E5%8E%BB%E4%BF%AE%E6%94%B9%E5%90%84%E4%B8%AAB%2B%E6%A0%91%E7%B4%A2%E5%BC%95%E3%80%82%E8%80%8C%E4%B8%94%E6%88%91%E4%BB%AC%E8%AE%B2%E8%BF%87%EF%BC%8CB%2B%E6%A0%91%E6%AF%8F%E5%B1%82%E8%8A%82%E7%82%B9%E9%83%BD%E6%98%AF%E6%8C%89%E7%85%A7%E7%B4%A2%E5%BC%95%E5%88%97%E7%9A%84%E5%80%BC%E4%BB%8E%E5%B0%8F%E5%88%B0%E5%A4%A7%E7%9A%84%E9%A1%BA%E5%BA%8F%E6%8E%92%E5%BA%8F%E8%80%8C%E7%BB%84%E6%88%90%E4%BA%86%E5%8F%8C%E5%90%91%E9%93%BE%E8%A1%A8%E3%80%82%E4%B8%8D%E8%AE%BA%E6%98%AF%E5%8F%B6%E5%AD%90%E8%8A%82%E7%82%B9%E4%B8%AD%E7%9A%84%E8%AE%B0%E5%BD%95%EF%BC%8C%E8%BF%98%E6%98%AF%E5%86%85%E8%8A%82%E7%82%B9%E4%B8%AD%E7%9A%84%E8%AE%B0%E5%BD%95%EF%BC%88%E4%B9%9F%E5%B0%B1%E6%98%AF%E4%B8%8D%E8%AE%BA%E6%98%AF%E7%94%A8%E6%88%B7%E8%AE%B0%E5%BD%95%E8%BF%98%E6%98%AF%E7%9B%AE%E5%BD%95%E9%A1%B9%E8%AE%B0%E5%BD%95%EF%BC%89%E9%83%BD%E6%98%AF%E6%8C%89%E7%85%A7%E7%B4%A2%E5%BC%95%E5%88%97%E7%9A%84%E5%80%BC%E4%BB%8E%E5%B0%8F%E5%88%B0%E5%A4%A7%E7%9A%84%E9%A1%BA%E5%BA%8F%E8%80%8C%E5%BD%A2%E6%88%90%E4%BA%86%E4%B8%80%E4%B8%AA%E5%8D%95%E5%90%91%E9%93%BE%E8%A1%A8%E3%80%82%E8%80%8C%E5%A2%9E%E3%80%81%E5%88%A0%E3%80%81%E6%94%B9%E6%93%8D%E4%BD%9C%E5%8F%AF%E8%83%BD%E4%BC%9A%E5%AF%B9%E8%8A%82%E7%82%B9%E5%92%8C%E8%AE%B0%E5%BD%95%E7%9A%84%E6%8E%92%E5%BA%8F%E9%80%A0%E6%88%90%E7%A0%B4%E5%9D%8F%EF%BC%8C%E6%89%80%E4%BB%A5%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E9%9C%80%E8%A6%81%E9%A2%9D%E5%A4%96%E7%9A%84%E6%97%B6%E9%97%B4%E8%BF%9B%E8%A1%8C%E4%B8%80%E4%BA%9B%E8%AE%B0%E5%BD%95%E7%A7%BB%E4%BD%8D%EF%BC%8C%E9%A1%B5%E9%9D%A2%E5%88%86%E8%A3%82%E3%80%81%E9%A1%B5%E9%9D%A2%E5%9B%9E%E6%94%B6%E5%95%A5%E7%9A%84%E6%93%8D%E4%BD%9C%E6%9D%A5%E7%BB%B4%E6%8A%A4%E5%A5%BD%E8%8A%82%E7%82%B9%E5%92%8C%E8%AE%B0%E5%BD%95%E7%9A%84%E6%8E%92%E5%BA%8F%E3%80%82%0A%0A%E6%89%80%E4%BB%A5%E8%AF%B4%EF%BC%8C%E4%B8%80%E4%B8%AA%E8%A1%A8%E4%B8%8A%E7%B4%A2%E5%BC%95%E5%BB%BA%E7%9A%84%E8%B6%8A%E5%A4%9A%EF%BC%8C%E5%B0%B1%E4%BC%9A%E5%8D%A0%E7%94%A8%E8%B6%8A%E5%A4%9A%E7%9A%84%E5%AD%98%E5%82%A8%E7%A9%BA%E9%97%B4%EF%BC%8C%E5%9C%A8%E5%A2%9E%E5%88%A0%E6%94%B9%E8%AE%B0%E5%BD%95%E7%9A%84%E6%97%B6%E5%80%99%E6%80%A7%E8%83%BD%E5%B0%B1%E8%B6%8A%E5%B7%AE%E3%80%82%0A%0A%23%23%202.%20B%2B%E6%A0%91%E7%B4%A2%E5%BC%95%E7%9A%84%E9%80%82%E7%94%A8%E6%9D%A1%E4%BB%B6%0A%E5%85%88%E5%88%9B%E5%BB%BA%E4%B8%80%E4%B8%AA%E7%A4%BA%E4%BE%8B%E8%A1%A8%EF%BC%9A%0A%0ACREATE%20TABLE%20person_info(%20%0A%20%20%20%20id%20INT%20NOT%20NULL%20auto_increment%2C%0A%20%20%20%20name%20VARCHAR(100)%20NOT%20NULL%2C%0A%20%20%20%20birthday%20DATE%20NOT%20NULL%2C%0A%20%20%20%20phone_number%20CHAR(11)%20NOT%20NULL%2C%0A%20%20%20%20country%20varchar(100)%20NOT%20NULL%2C%0A%20%20%20%20PRIMARY%20KEY%20(id)%2C%20%0A%20%20%20%20KEY%20idx_name_birthday_phone_number%20(name%2C%20birthday%2C%20phone_number)%0A)%3B%0A%0A%0Aperson_info%E8%A1%A8%E4%BC%9A%E4%B8%BA%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%E5%92%8Cidx_name_birthday_phone_number%E7%B4%A2%E5%BC%95%E5%BB%BA%E7%AB%8B2%E6%A3%B5B%2B%E6%A0%91%E3%80%82idx_name_birthday_phone_number%E7%9A%84B%2B%E6%A0%91%E4%B8%AD%0A%E5%9C%A8%E8%AE%B0%E5%BD%95%E7%BB%93%E6%9E%84%E4%B8%AD%E5%8F%AA%E4%BF%9D%E7%95%99name%E3%80%81birthday%E3%80%81phone_number%E3%80%81id%E8%BF%99%E5%9B%9B%E4%B8%AA%E5%88%97%E7%9A%84%E7%9C%9F%E5%AE%9E%E6%95%B0%E6%8D%AE%E5%80%BC%EF%BC%8C%E7%A4%BA%E6%84%8F%E5%9B%BE%E5%A6%82%E4%B8%8B%EF%BC%9A%0A!%5B0bd8085a9b70aa881feadc1ccf90a5de.jpeg%5D(en-resource%3A%2F%2Fdatabase%2F679%3A1)%0A%0A%E4%BB%8E%E5%9B%BE%E4%B8%AD%E5%8F%AF%E4%BB%A5%E7%9C%8B%E5%87%BA%EF%BC%8C%E8%BF%99%E4%B8%AAidx_name_birthday_phone_number%E7%B4%A2%E5%BC%95%E5%AF%B9%E5%BA%94%E7%9A%84B%2B%E6%A0%91%E4%B8%AD%E9%A1%B5%E9%9D%A2%E5%92%8C%E8%AE%B0%E5%BD%95%E7%9A%84%E6%8E%92%E5%BA%8F%E6%96%B9%E5%BC%8F%E5%B0%B1%E6%98%AF%E8%BF%99%E6%A0%B7%E7%9A%84%EF%BC%9A%0A%0A*%20%E5%85%88%E6%8C%89%E7%85%A7name%E5%88%97%E7%9A%84%E5%80%BC%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%EF%BC%9B%0A*%20%E5%A6%82%E6%9E%9Cname%E5%88%97%E7%9A%84%E5%80%BC%E7%9B%B8%E5%90%8C%EF%BC%8C%E5%88%99%E6%8C%89%E7%85%A7birthday%E5%88%97%E7%9A%84%E5%80%BC%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%EF%BC%9B%0A*%20%E5%A6%82%E6%9E%9Cbirthday%E5%88%97%E7%9A%84%E5%80%BC%E4%B9%9F%E7%9B%B8%E5%90%8C%EF%BC%8C%E5%88%99%E6%8C%89%E7%85%A7phone_number%E7%9A%84%E5%80%BC%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%EF%BC%9B%0A%0A%E8%BF%99%E4%B8%AA%E6%8E%92%E5%BA%8F%E6%96%B9%E5%BC%8F%E5%8D%81%E5%88%86%E3%80%81%E7%89%B9%E5%88%AB%E3%80%81%E9%9D%9E%E5%B8%B8%E3%80%81%E5%B7%A8%E3%80%81very%20very%20very%E9%87%8D%E8%A6%81%EF%BC%8C%E5%9B%A0%E4%B8%BA%E5%8F%AA%E8%A6%81%E9%A1%B5%E9%9D%A2%E5%92%8C%E8%AE%B0%E5%BD%95%E6%98%AF%E6%8E%92%E5%A5%BD%E5%BA%8F%E7%9A%84%EF%BC%8C%E5%B0%B1%E5%8F%AF%E4%BB%A5%E9%80%9A%E8%BF%87%E4%BA%8C%E5%88%86%E6%B3%95%E6%9D%A5%E5%BF%AB%E9%80%9F%E5%AE%9A%E4%BD%8D%E6%9F%A5%E6%89%BE%E3%80%82%0A%0A%23%23%23%23%20%E5%85%A8%E5%80%BC%E5%8C%B9%E9%85%8D%0A%0A%E5%A6%82%E6%9E%9C%E6%88%91%E4%BB%AC%E7%9A%84%E6%90%9C%E7%B4%A2%E6%9D%A1%E4%BB%B6%E4%B8%AD%E7%9A%84%E5%88%97%E5%92%8C%E7%B4%A2%E5%BC%95%E5%88%97%E4%B8%80%E8%87%B4%E7%9A%84%E8%AF%9D%EF%BC%8C%E8%BF%99%E7%A7%8D%E6%83%85%E5%86%B5%E5%B0%B1%E7%A7%B0%E4%B8%BA%E5%85%A8%E5%80%BC%E5%8C%B9%E9%85%8D%EF%BC%8C%E6%AF%94%E6%96%B9%E8%AF%B4%E4%B8%8B%E8%BE%B9%E8%BF%99%E4%B8%AA%E6%9F%A5%E6%89%BE%E8%AF%AD%E5%8F%A5%EF%BC%9A%0A%0A**SELECT%20*%20FROM%20person_info%20WHERE%20name%20%3D%20'Ashburn'%20AND%20birthday%20%3D%20'1990-09-27'%20AND%20phone_number%20%3D%20'15123983239'%3B**%0A%0A%0A%23%23%23%23%20%E6%9C%80%E5%B7%A6%E5%89%8D%E7%BC%80%E5%8C%B9%E9%85%8D%0A%0A**%E5%A6%82%E6%9E%9C%E6%83%B3%E4%BD%BF%E7%94%A8%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E4%B8%AD%E5%B0%BD%E5%8F%AF%E8%83%BD%E5%A4%9A%E7%9A%84%E5%88%97%EF%BC%8C%E6%90%9C%E7%B4%A2%E6%9D%A1%E4%BB%B6%E4%B8%AD%E7%9A%84%E5%90%84%E4%B8%AA%E5%88%97%E5%BF%85%E9%A1%BB%E6%98%AF%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E4%B8%AD%E4%BB%8E%E6%9C%80%E5%B7%A6%E8%BE%B9%E8%BF%9E%E7%BB%AD%E7%9A%84%E5%88%97%E3%80%82**%0A%0A%E9%82%A3%E4%B8%BA%E4%BB%80%E4%B9%88%E6%90%9C%E7%B4%A2%E6%9D%A1%E4%BB%B6%E4%B8%AD%E5%BF%85%E9%A1%BB%E5%87%BA%E7%8E%B0%E5%B7%A6%E8%BE%B9%E7%9A%84%E5%88%97%E6%89%8D%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%E5%88%B0%E8%BF%99%E4%B8%AAB%2B%E6%A0%91%E7%B4%A2%E5%BC%95%E5%91%A2%EF%BC%9F%E6%AF%94%E5%A6%82%E4%B8%8B%E8%BE%B9%E7%9A%84%E8%AF%AD%E5%8F%A5%E5%B0%B1%E7%94%A8%E4%B8%8D%E5%88%B0%E8%BF%99%E4%B8%AAB%2B%E6%A0%91%E7%B4%A2%E5%BC%95%EF%BC%9A%0A%0A**SELECT%20*%20FROM%20person_info%20WHERE%20birthday%20%3D%20'1990-09-27'%3B**%0A%0A%E5%9B%A0%E4%B8%BAB%2B%E6%A0%91%E7%9A%84%E6%95%B0%E6%8D%AE%E9%A1%B5%E5%92%8C%E8%AE%B0%E5%BD%95%E5%85%88%E6%98%AF%E6%8C%89%E7%85%A7name%E5%88%97%E7%9A%84%E5%80%BC%E6%8E%92%E5%BA%8F%E7%9A%84%EF%BC%8C%E5%9C%A8name%E5%88%97%E7%9A%84%E5%80%BC%E7%9B%B8%E5%90%8C%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%E6%89%8D%E4%BD%BF%E7%94%A8birthday%E5%88%97%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%EF%BC%8C%E4%B9%9F%E5%B0%B1%E6%98%AF%E8%AF%B4name%E5%88%97%E7%9A%84%E5%80%BC%E4%B8%8D%E5%90%8C%E7%9A%84%E8%AE%B0%E5%BD%95%E4%B8%ADbirthday%E7%9A%84%E5%80%BC%E5%8F%AF%E8%83%BD%E6%98%AF%E6%97%A0%E5%BA%8F%E7%9A%84%E3%80%82%0A%0A%23%23%23%23%20%E5%8C%B9%E9%85%8D%E5%88%97%E5%89%8D%E7%BC%80%0A%E5%9C%A8%E6%9F%90%E5%AD%97%E7%AC%A6%E4%B8%B2%E4%B8%8A%E7%9A%84%E5%88%97%E5%BB%BA%E7%AB%8B%E7%B4%A2%E5%BC%95%E6%97%B6%EF%BC%8C%E8%BF%99%E4%BA%9B%E5%AD%97%E7%AC%A6%E4%B8%B2%E7%9A%84%E5%89%8Dn%E4%B8%AA%E5%AD%97%E7%AC%A6%EF%BC%8C%E4%B9%9F%E5%B0%B1%E6%98%AF%E5%89%8D%E7%BC%80%E9%83%BD%E6%98%AF%E6%8E%92%E5%A5%BD%E5%BA%8F%E7%9A%84%EF%BC%8C%E6%89%80%E4%BB%A5%E5%AF%B9%E4%BA%8E%E5%AD%97%E7%AC%A6%E4%B8%B2%E7%B1%BB%E5%9E%8B%E7%9A%84%E7%B4%A2%E5%BC%95%E5%88%97%E6%9D%A5%E8%AF%B4%EF%BC%8C%E6%88%91%E4%BB%AC%E5%8F%AA%E5%8C%B9%E9%85%8D%E5%AE%83%E7%9A%84%E5%89%8D%E7%BC%80%E4%B9%9F%E6%98%AF%E5%8F%AF%E4%BB%A5%E5%BF%AB%E9%80%9F%E5%AE%9A%E4%BD%8D%E8%AE%B0%E5%BD%95%E7%9A%84%EF%BC%8C%E6%AF%94%E6%96%B9%E8%AF%B4%E6%88%91%E4%BB%AC%E6%83%B3%E6%9F%A5%E8%AF%A2%E5%90%8D%E5%AD%97%E4%BB%A5'As'%E5%BC%80%E5%A4%B4%E7%9A%84%E8%AE%B0%E5%BD%95%EF%BC%8C%E9%82%A3%E5%B0%B1%E5%8F%AF%E4%BB%A5%E8%BF%99%E4%B9%88%E5%86%99%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%EF%BC%9A%0A%0A**SELECT%20*%20FROM%20person_info%20WHERE%20name%20LIKE%20'As%25'%EF%BC%9B**%0A%E6%B3%A8%E6%84%8F%E8%BF%99%E9%87%8C%E7%9A%84LIKE%E6%98%AF%E6%9C%80%E5%B7%A6%E7%AB%AF%E7%B2%BE%E7%A1%AE%E5%8C%B9%E9%85%8D%E3%80%82%0A%0A%23%23%23%23%20%E5%8C%B9%E9%85%8D%E8%8C%83%E5%9B%B4%E5%80%BC%0A%0Aidx_name_birthday_phone_number%E7%B4%A2%E5%BC%95%E7%9A%84B%2B%E6%A0%91%E7%A4%BA%E6%84%8F%E5%9B%BE%EF%BC%8C%E6%89%80%E6%9C%89%E8%AE%B0%E5%BD%95%E9%83%BD%E6%98%AF%E6%8C%89%E7%85%A7%E7%B4%A2%E5%BC%95%E5%88%97%E7%9A%84%E5%80%BC%E4%BB%8E%E5%B0%8F%E5%88%B0%E5%A4%A7%E7%9A%84%E9%A1%BA%E5%BA%8F%E6%8E%92%E5%A5%BD%E5%BA%8F%E7%9A%84%EF%BC%8C%E6%89%80%E4%BB%A5%E8%BF%99%E6%9E%81%E5%A4%A7%E7%9A%84%E6%96%B9%E4%BE%BF%E6%88%91%E4%BB%AC%E6%9F%A5%E6%89%BE%E7%B4%A2%E5%BC%95%E5%88%97%E7%9A%84%E5%80%BC%E5%9C%A8%E6%9F%90%E4%B8%AA%E8%8C%83%E5%9B%B4%E5%86%85%E7%9A%84%E8%AE%B0%E5%BD%95%E3%80%82%E6%AF%94%E6%96%B9%E8%AF%B4%E4%B8%8B%E8%BE%B9%E8%BF%99%E4%B8%AA%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%EF%BC%9A%0A%0A**SELECT%20*%20FROM%20person_info%20WHERE%20name%20%3E%20'Asa'%20AND%20name%20%3C%20'Barlow'%EF%BC%9B**%0A%0A%0A%E4%B8%8D%E8%BF%87%E5%9C%A8%E4%BD%BF%E7%94%A8%E8%81%94%E5%90%88%E8%BF%9B%E8%A1%8C%E8%8C%83%E5%9B%B4%E6%9F%A5%E6%89%BE%E7%9A%84%E6%97%B6%E5%80%99%E9%9C%80%E8%A6%81%E6%B3%A8%E6%84%8F%EF%BC%8C%E5%A6%82%E6%9E%9C%E5%AF%B9%E5%A4%9A%E4%B8%AA%E5%88%97%E5%90%8C%E6%97%B6%E8%BF%9B%E8%A1%8C%E8%8C%83%E5%9B%B4%E6%9F%A5%E6%89%BE%E7%9A%84%E8%AF%9D%EF%BC%8C%E5%8F%AA%E6%9C%89%E5%AF%B9%E7%B4%A2%E5%BC%95%E6%9C%80%E5%B7%A6%E8%BE%B9%E7%9A%84%E9%82%A3%E4%B8%AA%E5%88%97%E8%BF%9B%E8%A1%8C%E8%8C%83%E5%9B%B4%E6%9F%A5%E6%89%BE%E7%9A%84%E6%97%B6%E5%80%99%E6%89%8D%E8%83%BD%E7%94%A8%E5%88%B0B%2B%E6%A0%91%E7%B4%A2%E5%BC%95%EF%BC%8C%E6%AF%94%E6%96%B9%E8%AF%B4%E8%BF%99%E6%A0%B7%EF%BC%9A%0A%0A**SELECT%20*%20FROM%20person_info%20WHERE%20name%20%3E%20'Asa'%20AND%20name%20%3C%20'Barlow'%20AND%20birthday%20%3E%20'1980-01-01'%EF%BC%9B**%0A%0A%E8%BF%99%E6%A0%B7%E5%AD%90%E5%AF%B9%E4%BA%8E%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95idx_name_birthday_phone_number%E6%9D%A5%E8%AF%B4%EF%BC%8C%E5%8F%AA%E8%83%BD%E7%94%A8%E5%88%B0name%E5%88%97%E7%9A%84%E9%83%A8%E5%88%86%EF%BC%8C%E8%80%8C%E7%94%A8%E4%B8%8D%E5%88%B0birthday%E5%88%97%E7%9A%84%E9%83%A8%E5%88%86%EF%BC%8C%E5%9B%A0%E4%B8%BA%E5%8F%AA%E6%9C%89name%E5%80%BC%E7%9B%B8%E5%90%8C%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%E6%89%8D%E8%83%BD%E7%94%A8birthday%E5%88%97%E7%9A%84%E5%80%BC%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%EF%BC%8C%E8%80%8C%E8%BF%99%E4%B8%AA%E6%9F%A5%E8%AF%A2%E4%B8%AD%E9%80%9A%E8%BF%87name%E8%BF%9B%E8%A1%8C%E8%8C%83%E5%9B%B4%E6%9F%A5%E6%89%BE%E7%9A%84%E8%AE%B0%E5%BD%95%E4%B8%AD%E5%8F%AF%E8%83%BD%E5%B9%B6%E4%B8%8D%E6%98%AF%E6%8C%89%E7%85%A7birthday%E5%88%97%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%E7%9A%84%EF%BC%8C%E6%89%80%E4%BB%A5%E5%9C%A8%E6%90%9C%E7%B4%A2%E6%9D%A1%E4%BB%B6%E4%B8%AD%E7%BB%A7%E7%BB%AD%E4%BB%A5birthday%E5%88%97%E8%BF%9B%E8%A1%8C%E6%9F%A5%E6%89%BE%E6%97%B6%E6%98%AF%E7%94%A8%E4%B8%8D%E5%88%B0%E8%BF%99%E4%B8%AAB%2B%E6%A0%91%E7%B4%A2%E5%BC%95%E7%9A%84%E3%80%82%0A%0A%23%23%23%23%20%E7%B2%BE%E7%A1%AE%E5%8C%B9%E9%85%8D%E6%9F%90%E4%B8%80%E5%88%97%E5%B9%B6%E8%8C%83%E5%9B%B4%E5%8C%B9%E9%85%8D%E5%8F%A6%E5%A4%96%E4%B8%80%E5%88%97%0A%0A%E5%AF%B9%E4%BA%8E%E5%90%8C%E4%B8%80%E4%B8%AA%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E6%9D%A5%E8%AF%B4%EF%BC%8C%E8%99%BD%E7%84%B6%E5%AF%B9%E5%A4%9A%E4%B8%AA%E5%88%97%E9%83%BD%E8%BF%9B%E8%A1%8C%E8%8C%83%E5%9B%B4%E6%9F%A5%E6%89%BE%E6%97%B6%E5%8F%AA%E8%83%BD%E7%94%A8%E5%88%B0%E6%9C%80%E5%B7%A6%E8%BE%B9%E9%82%A3%E4%B8%AA%E7%B4%A2%E5%BC%95%E5%88%97%EF%BC%8C%E4%BD%86%E6%98%AF%E5%A6%82%E6%9E%9C%E5%B7%A6%E8%BE%B9%E7%9A%84%E5%88%97%E6%98%AF%E7%B2%BE%E7%A1%AE%E6%9F%A5%E6%89%BE%EF%BC%8C%E5%88%99%E5%8F%B3%E8%BE%B9%E7%9A%84%E5%88%97%E5%8F%AF%E4%BB%A5%E8%BF%9B%E8%A1%8C%E8%8C%83%E5%9B%B4%E6%9F%A5%E6%89%BE%EF%BC%8C%E6%AF%94%E6%96%B9%E8%AF%B4%E8%BF%99%E6%A0%B7%EF%BC%9A%0A%0A**SELECT%20*%20FROM%20person_info%20WHERE%20name%20%3D%20'Ashburn'%20AND%20birthday%20%3D%20'1980-01-01'%20AND%20AND%20phone_number%20%3E%20'15100000000'%EF%BC%9B**%0A%0A%23%23%23%23%20%E7%94%A8%E4%BA%8E%E6%8E%92%E5%BA%8F%0A%0A%E5%9C%A8%E5%86%99%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%E7%9A%84%E6%97%B6%E5%80%99%E7%BB%8F%E5%B8%B8%E9%9C%80%E8%A6%81%E5%AF%B9%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%9D%A5%E7%9A%84%E8%AE%B0%E5%BD%95%E9%80%9A%E8%BF%87ORDER%20BY%E5%AD%90%E5%8F%A5%E6%8C%89%E7%85%A7%E6%9F%90%E7%A7%8D%E8%A7%84%E5%88%99%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%E3%80%82%E4%B8%80%E8%88%AC%E6%83%85%E5%86%B5%E4%B8%8B%EF%BC%8C%E6%88%91%E4%BB%AC%E5%8F%AA%E8%83%BD%E6%8A%8A%E8%AE%B0%E5%BD%95%E9%83%BD%E5%8A%A0%E8%BD%BD%E5%88%B0%E5%86%85%E5%AD%98%E4%B8%AD%EF%BC%8C%E5%86%8D%E7%94%A8%E4%B8%80%E4%BA%9B%E6%8E%92%E5%BA%8F%E7%AE%97%E6%B3%95%EF%BC%8C%E6%AF%94%E5%A6%82%E5%BF%AB%E9%80%9F%E6%8E%92%E5%BA%8F%E3%80%81%E5%BD%92%E5%B9%B6%E6%8E%92%E5%BA%8F%E3%80%81%E5%90%A7%E5%95%A6%E5%90%A7%E5%95%A6%E6%8E%92%E5%BA%8F%E7%AD%89%E7%AD%89%E5%9C%A8%E5%86%85%E5%AD%98%E4%B8%AD%E5%AF%B9%E8%BF%99%E4%BA%9B%E8%AE%B0%E5%BD%95%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%EF%BC%8C%E6%9C%89%E7%9A%84%E6%97%B6%E5%80%99%E5%8F%AF%E8%83%BD%E6%9F%A5%E8%AF%A2%E7%9A%84%E7%BB%93%E6%9E%9C%E9%9B%86%E5%A4%AA%E5%A4%A7%E4%BB%A5%E8%87%B3%E4%BA%8E%E4%B8%8D%E8%83%BD%E5%9C%A8%E5%86%85%E5%AD%98%E4%B8%AD%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%E7%9A%84%E8%AF%9D%EF%BC%8C%E8%BF%98%E5%8F%AF%E8%83%BD%E6%9A%82%E6%97%B6%E5%80%9F%E5%8A%A9%E7%A3%81%E7%9B%98%E7%9A%84%E7%A9%BA%E9%97%B4%E6%9D%A5%E5%AD%98%E6%94%BE%E4%B8%AD%E9%97%B4%E7%BB%93%E6%9E%9C%EF%BC%8C%E6%8E%92%E5%BA%8F%E6%93%8D%E4%BD%9C%E5%AE%8C%E6%88%90%E5%90%8E%E5%86%8D%E6%8A%8A%E6%8E%92%E5%A5%BD%E5%BA%8F%E7%9A%84%E7%BB%93%E6%9E%9C%E9%9B%86%E8%BF%94%E5%9B%9E%E5%88%B0%E5%AE%A2%E6%88%B7%E7%AB%AF%E3%80%82%E5%9C%A8MySQL%E4%B8%AD%EF%BC%8C%E6%8A%8A%E8%BF%99%E7%A7%8D**%E5%9C%A8%E5%86%85%E5%AD%98%E4%B8%AD%E6%88%96%E8%80%85%E7%A3%81%E7%9B%98%E4%B8%8A%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%E7%9A%84%E6%96%B9%E5%BC%8F%E7%BB%9F%E7%A7%B0%E4%B8%BA%E6%96%87%E4%BB%B6%E6%8E%92%E5%BA%8F%EF%BC%88%E8%8B%B1%E6%96%87%E5%90%8D%EF%BC%9Afilesort%EF%BC%89**%EF%BC%8C%E8%B7%9F%E6%96%87%E4%BB%B6%E8%BF%99%E4%B8%AA%E8%AF%8D%E5%84%BF%E4%B8%80%E6%B2%BE%E8%BE%B9%E5%84%BF%EF%BC%8C%E5%B0%B1%E6%98%BE%E5%BE%97%E8%BF%99%E4%BA%9B%E6%8E%92%E5%BA%8F%E6%93%8D%E4%BD%9C%E9%9D%9E%E5%B8%B8%E6%85%A2%E4%BA%86%EF%BC%88%E7%A3%81%E7%9B%98%E5%92%8C%E5%86%85%E5%AD%98%E7%9A%84%E9%80%9F%E5%BA%A6%E6%AF%94%E8%B5%B7%E6%9D%A5%EF%BC%8C%E5%B0%B1%E5%83%8F%E6%98%AF%E9%A3%9E%E6%9C%BA%E5%92%8C%E8%9C%97%E7%89%9B%E7%9A%84%E5%AF%B9%E6%AF%94%EF%BC%89%E3%80%82%E4%BD%86%E6%98%AF%E5%A6%82%E6%9E%9CORDER%20BY%E5%AD%90%E5%8F%A5%E9%87%8C%E4%BD%BF%E7%94%A8%E5%88%B0%E4%BA%86%E6%88%91%E4%BB%AC%E7%9A%84%E7%B4%A2%E5%BC%95%E5%88%97%EF%BC%8C%E5%B0%B1%E6%9C%89%E5%8F%AF%E8%83%BD%E7%9C%81%E5%8E%BB%E5%9C%A8%E5%86%85%E5%AD%98%E6%88%96%E6%96%87%E4%BB%B6%E4%B8%AD%E6%8E%92%E5%BA%8F%E7%9A%84%E6%AD%A5%E9%AA%A4%EF%BC%8C%E6%AF%94%E5%A6%82%E4%B8%8B%E8%BE%B9%E8%BF%99%E4%B8%AA%E7%AE%80%E5%8D%95%E7%9A%84%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%EF%BC%9A%0A%0A**SELECT%20*%20FROM%20person_info%20ORDER%20BY%20name%2C%20birthday%2C%20phone_number%20LIMIT%2010%EF%BC%9B**%0A%0A%23%23%23%23%20%E4%BD%BF%E7%94%A8%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%E6%B3%A8%E6%84%8F%E4%BA%8B%E9%A1%B9%0A%0A%E5%AF%B9%E4%BA%8E%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E6%9C%89%E4%B8%AA%E9%97%AE%E9%A2%98%E9%9C%80%E8%A6%81%E6%B3%A8%E6%84%8F%EF%BC%8CORDER%20BY%E7%9A%84%E5%AD%90%E5%8F%A5%E5%90%8E%E8%BE%B9%E7%9A%84%E5%88%97%E7%9A%84%E9%A1%BA%E5%BA%8F%E4%B9%9F%E5%BF%85%E9%A1%BB%E6%8C%89%E7%85%A7%E7%B4%A2%E5%BC%95%E5%88%97%E7%9A%84%E9%A1%BA%E5%BA%8F%E7%BB%99%E5%87%BA%EF%BC%8C%E5%A6%82%E6%9E%9C%E7%BB%99%E5%87%BAORDER%20BY%20phone_number%2C%20birthday%2C%20name%E7%9A%84%E9%A1%BA%E5%BA%8F%EF%BC%8C%E9%82%A3%E4%B9%9F%E6%98%AF%E7%94%A8%E4%B8%8D%E4%BA%86B%2B%E6%A0%91%E7%B4%A2%E5%BC%95%E3%80%82%0A%0A%E5%90%8C%E7%90%86%EF%BC%8CORDER%20BY%20name%E3%80%81ORDER%20BY%20name%2C%20birthday%E8%BF%99%E7%A7%8D%E5%8C%B9%E9%85%8D%E7%B4%A2%E5%BC%95%E5%B7%A6%E8%BE%B9%E7%9A%84%E5%88%97%E7%9A%84%E5%BD%A2%E5%BC%8F%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%E9%83%A8%E5%88%86%E7%9A%84B%2B%E6%A0%91%E7%B4%A2%E5%BC%95%E3%80%82%E5%BD%93%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E5%B7%A6%E8%BE%B9%E5%88%97%E7%9A%84%E5%80%BC%E4%B8%BA%E5%B8%B8%E9%87%8F%EF%BC%8C%E4%B9%9F%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%E5%90%8E%E8%BE%B9%E7%9A%84%E5%88%97%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%EF%BC%8C%E6%AF%94%E5%A6%82%E8%BF%99%E6%A0%B7%EF%BC%9A%0A%0A**SELECT%20*%20FROM%20person_info%20WHERE%20name%20%3D%20'A'%20ORDER%20BY%20birthday%2C%20phone_number%20LIMIT%2010%EF%BC%9B**%0A%0A%23%23%23%23%20%E4%B8%8D%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%E7%B4%A2%E5%BC%95%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%E7%9A%84%E5%87%A0%E7%A7%8D%E6%83%85%E5%86%B5%0A1.%20**ASC%E3%80%81DESC%E6%B7%B7%E7%94%A8**%EF%BC%8C%E5%A6%82%EF%BC%9ASELECT%20*%20FROM%20person_info%20ORDER%20BY%20name%2C%20birthday%20DESC%20LIMIT%2010%EF%BC%9B%0A2.%20**WHERE%E5%AD%90%E5%8F%A5%E4%B8%AD%E5%87%BA%E7%8E%B0%E9%9D%9E%E6%8E%92%E5%BA%8F%E4%BD%BF%E7%94%A8%E5%88%B0%E7%9A%84%E7%B4%A2%E5%BC%95%E5%88%97**%EF%BC%8C%E5%A6%82%EF%BC%9ASELECT%20*%20FROM%20person_info%20WHERE%20country%20%3D%20'China'%20ORDER%20BY%20name%20LIMIT%2010%EF%BC%9B%0A3.%20**%E6%8E%92%E5%BA%8F%E5%88%97%E5%8C%85%E5%90%AB%E9%9D%9E%E5%90%8C%E4%B8%80%E4%B8%AA%E7%B4%A2%E5%BC%95%E7%9A%84%E5%88%97**%EF%BC%8C%E5%A6%82%EF%BC%9ASELECT%20*%20FROM%20person_info%20ORDER%20BY%20name%2C%20country%20LIMIT%2010%EF%BC%9B%0A4.%20**%E6%8E%92%E5%BA%8F%E5%88%97%E4%BD%BF%E7%94%A8%E4%BA%86%E5%A4%8D%E6%9D%82%E7%9A%84%E8%A1%A8%E8%BE%BE%E5%BC%8F**%EF%BC%8C%E5%A6%82%EF%BC%9ASELECT%20*%20FROM%20person_info%20ORDER%20BY%20UPPER(name)%20LIMIT%2010%EF%BC%9B%0A%0A%23%23%23%23%20%E7%94%A8%E4%BA%8E%E5%88%86%E7%BB%84%0A%E4%BD%BF%E7%94%A8B%2B%E6%A0%91%E7%B4%A2%E5%BC%95%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%E6%98%AF%E4%B8%80%E4%B8%AA%E9%81%93%E7%90%86%EF%BC%8C%E5%88%86%E7%BB%84%E5%88%97%E7%9A%84%E9%A1%BA%E5%BA%8F%E4%B9%9F%E9%9C%80%E8%A6%81%E5%92%8C%E7%B4%A2%E5%BC%95%E5%88%97%E7%9A%84%E9%A1%BA%E5%BA%8F%E4%B8%80%E8%87%B4%EF%BC%8C%E4%B9%9F%E5%8F%AF%E4%BB%A5%E5%8F%AA%E4%BD%BF%E7%94%A8%E7%B4%A2%E5%BC%95%E5%88%97%E4%B8%AD%E5%B7%A6%E8%BE%B9%E7%9A%84%E5%88%97%E8%BF%9B%E8%A1%8C%E5%88%86%E7%BB%84%EF%BC%9B%0A%0A%23%23%23%20%E5%85%B6%E4%BB%96%E5%87%A0%E7%A7%8D%E7%89%B9%E6%AE%8A%E7%9A%84%E7%B4%A2%E5%BC%95%E5%A4%B1%E6%95%88%E7%9A%84%E6%83%85%E5%86%B5%0A1.%20**%E5%9C%A8%E5%AF%B9%E5%AD%97%E7%AC%A6%E4%B8%B2%E5%AD%97%E6%AE%B5%E4%BD%BF%E7%94%A8%E7%B4%A2%E5%BC%95%E6%97%B6%EF%BC%8C%E9%9C%80%E8%A6%81%E6%B3%A8%E6%84%8F%E4%B8%80%E7%A7%8D%E7%89%B9%E6%AE%8A%E6%83%85%E5%86%B5%EF%BC%9A%E6%95%B0%E6%8D%AE%E7%B1%BB%E5%9E%8B%E7%9A%84%E9%9A%90%E5%BC%8F%E8%BD%AC%E6%8D%A2%EF%BC%8C%E8%BF%99%E7%A7%8D%E6%83%85%E5%86%B5%E4%BC%9A%E5%AF%BC%E8%87%B4%E7%B4%A2%E5%BC%95%E5%A4%B1%E6%95%88%E3%80%82**%0A2.%20**%E5%9C%A8%E4%BD%BF%E7%94%A8Limit%E5%88%86%E9%A1%B5%E6%97%B6%EF%BC%8C%E5%A6%82%E6%9E%9C%E6%95%B0%E6%8D%AE%E9%87%8F%E5%BE%88%E5%A4%A7%EF%BC%8C%E5%8F%AF%E8%83%BD%E4%BC%9A%E5%AF%BC%E8%87%B4%E7%B4%A2%E5%BC%95%E5%A4%B1%E6%95%88%EF%BC%88%E8%BF%99%E7%A7%8D%E6%83%85%E5%86%B5%E9%9C%80%E8%A6%81%E5%A5%BD%E5%A5%BD%E7%A0%94%E7%A9%B6%E4%B8%80%E4%B8%8B%EF%BC%8C%E6%9A%82%E6%97%B6%E8%BF%98%E6%B2%A1%E6%9C%89%E7%A1%AE%E5%AE%9A%EF%BC%89**%0A%0A%23%23%203.%20%E5%9B%9E%E8%A1%A8%E7%9A%84%E4%BB%A3%E4%BB%B7%0A%E4%B8%8A%E8%BE%B9%E7%9A%84%E8%AE%A8%E8%AE%BA%E5%AF%B9%E5%9B%9E%E8%A1%A8%E8%BF%99%E4%B8%AA%E8%AF%8D%E5%84%BF%E5%A4%9A%E6%98%AF%E4%B8%80%E5%B8%A6%E8%80%8C%E8%BF%87%EF%BC%8C%E5%8F%AF%E8%83%BD%E5%A4%A7%E5%AE%B6%E6%B2%A1%E5%95%A5%E6%B7%B1%E5%88%BB%E7%9A%84%E4%BD%93%E4%BC%9A%EF%BC%8C%E4%B8%8B%E8%BE%B9%E6%88%91%E4%BB%AC%E8%AF%A6%E7%BB%86%E5%94%A0%E5%8F%A8%E4%B8%8B%E3%80%82%E8%BF%98%E6%98%AF%E7%94%A8idx_name_birthday_phone_number%E7%B4%A2%E5%BC%95%E4%B8%BA%E4%BE%8B%EF%BC%8C%E7%9C%8B%E4%B8%8B%E8%BE%B9%E8%BF%99%E4%B8%AA%E6%9F%A5%E8%AF%A2%EF%BC%9A%0A%0ASELECT%20*%20FROM%20person_info%20WHERE%20name%20%3E%20'Asa'%20AND%20name%20%3C%20'Barlow'%3B%0A%0A%E5%9C%A8%E4%BD%BF%E7%94%A8idx_name_birthday_phone_number%E7%B4%A2%E5%BC%95%E8%BF%9B%E8%A1%8C%E6%9F%A5%E8%AF%A2%E6%97%B6%E5%A4%A7%E8%87%B4%E5%8F%AF%E4%BB%A5%E5%88%86%E4%B8%BA%E8%BF%99%E4%B8%A4%E4%B8%AA%E6%AD%A5%E9%AA%A4%EF%BC%9A%0A1.%20%E4%BB%8E%E7%B4%A2%E5%BC%95idx_name_birthday_phone_number%E5%AF%B9%E5%BA%94%E7%9A%84B%2B%E6%A0%91%E4%B8%AD%E5%8F%96%E5%87%BAname%E5%80%BC%E5%9C%A8Asa%EF%BD%9EBarlow%E4%B9%8B%E9%97%B4%E7%9A%84%E7%94%A8%E6%88%B7%E8%AE%B0%E5%BD%95%EF%BC%9B%0A2.%20%E7%94%B1%E4%BA%8E%E7%B4%A2%E5%BC%95idx_name_birthday_phone_number%E5%AF%B9%E5%BA%94%E7%9A%84B%2B%E6%A0%91%E7%94%A8%E6%88%B7%E8%AE%B0%E5%BD%95%E4%B8%AD%E5%8F%AA%E5%8C%85%E5%90%ABname%E3%80%81birthday%E3%80%81phone_number%E3%80%81id%E8%BF%994%E4%B8%AA%E5%AD%97%E6%AE%B5%EF%BC%8C%E8%80%8C%E6%9F%A5%E8%AF%A2%E5%88%97%E8%A1%A8%E6%98%AF*%EF%BC%8C%E6%84%8F%E5%91%B3%E7%9D%80%E8%A6%81%E6%9F%A5%E8%AF%A2%E8%A1%A8%E4%B8%AD%E6%89%80%E6%9C%89%E5%AD%97%E6%AE%B5%EF%BC%8C%E4%B9%9F%E5%B0%B1%E6%98%AF%E8%BF%98%E8%A6%81%E5%8C%85%E6%8B%ACcountry%E5%AD%97%E6%AE%B5%E3%80%82%E8%BF%99%E6%97%B6%E9%9C%80%E8%A6%81%E6%8A%8A%E4%BB%8E%E4%B8%8A%E4%B8%80%E6%AD%A5%E4%B8%AD%E8%8E%B7%E5%8F%96%E5%88%B0%E7%9A%84%E6%AF%8F%E4%B8%80%E6%9D%A1%E8%AE%B0%E5%BD%95%E7%9A%84id%E5%AD%97%E6%AE%B5%E9%83%BD%E5%88%B0%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%E5%AF%B9%E5%BA%94%E7%9A%84B%2B%E6%A0%91%E4%B8%AD%E6%89%BE%E5%88%B0%E5%AE%8C%E6%95%B4%E7%9A%84%E7%94%A8%E6%88%B7%E8%AE%B0%E5%BD%95%EF%BC%8C%E4%B9%9F%E5%B0%B1%E6%98%AF%E6%88%91%E4%BB%AC%E9%80%9A%E5%B8%B8%E6%89%80%E8%AF%B4%E7%9A%84**%E5%9B%9E%E8%A1%A8**%EF%BC%8C%E7%84%B6%E5%90%8E%E6%8A%8A%E5%AE%8C%E6%95%B4%E7%9A%84%E7%94%A8%E6%88%B7%E8%AE%B0%E5%BD%95%E8%BF%94%E5%9B%9E%E7%BB%99%E6%9F%A5%E8%AF%A2%E7%94%A8%E6%88%B7%EF%BC%9B%0A%0A%E7%94%B1%E4%BA%8E%E7%B4%A2%E5%BC%95idx_name_birthday_phone_number%E5%AF%B9%E5%BA%94%E7%9A%84B%2B%E6%A0%91%E4%B8%AD%E7%9A%84%E8%AE%B0%E5%BD%95%E9%A6%96%E5%85%88%E4%BC%9A%E6%8C%89%E7%85%A7name%E5%88%97%E7%9A%84%E5%80%BC%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%EF%BC%8C%E6%89%80%E4%BB%A5%E5%80%BC%E5%9C%A8Asa%EF%BD%9EBarlow%E4%B9%8B%E9%97%B4%E7%9A%84%E8%AE%B0%E5%BD%95%E5%9C%A8%E7%A3%81%E7%9B%98%E4%B8%AD%E7%9A%84%E5%AD%98%E5%82%A8%E6%98%AF%E7%9B%B8%E8%BF%9E%E7%9A%84%EF%BC%8C%E9%9B%86%E4%B8%AD%E5%88%86%E5%B8%83%E5%9C%A8%E4%B8%80%E4%B8%AA%E6%88%96%E5%87%A0%E4%B8%AA%E6%95%B0%E6%8D%AE%E9%A1%B5%E4%B8%AD%EF%BC%8C%E6%88%91%E4%BB%AC%E5%8F%AF%E4%BB%A5%E5%BE%88%E5%BF%AB%E7%9A%84%E6%8A%8A%E8%BF%99%E4%BA%9B%E8%BF%9E%E7%9D%80%E7%9A%84%E8%AE%B0%E5%BD%95%E4%BB%8E%E7%A3%81%E7%9B%98%E4%B8%AD%E8%AF%BB%E5%87%BA%E6%9D%A5%EF%BC%8C%E8%BF%99%E7%A7%8D%E8%AF%BB%E5%8F%96%E6%96%B9%E5%BC%8F%E6%88%91%E4%BB%AC%E4%B9%9F%E5%8F%AF%E4%BB%A5%E7%A7%B0%E4%B8%BA**%E9%A1%BA%E5%BA%8FI%2FO**%E3%80%82%E6%A0%B9%E6%8D%AE%E7%AC%AC1%E6%AD%A5%E4%B8%AD%E8%8E%B7%E5%8F%96%E5%88%B0%E7%9A%84%E8%AE%B0%E5%BD%95%E7%9A%84id%E5%AD%97%E6%AE%B5%E7%9A%84%E5%80%BC%E5%8F%AF%E8%83%BD%E5%B9%B6%E4%B8%8D%E7%9B%B8%E8%BF%9E%EF%BC%8C%E8%80%8C%E5%9C%A8%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%E4%B8%AD%E8%AE%B0%E5%BD%95%E6%98%AF%E6%A0%B9%E6%8D%AEid%EF%BC%88%E4%B9%9F%E5%B0%B1%E6%98%AF%E4%B8%BB%E9%94%AE%EF%BC%89%E7%9A%84%E9%A1%BA%E5%BA%8F%E6%8E%92%E5%88%97%E7%9A%84%EF%BC%8C%E6%89%80%E4%BB%A5%E6%A0%B9%E6%8D%AE%E8%BF%99%E4%BA%9B%E5%B9%B6%E4%B8%8D%E8%BF%9E%E7%BB%AD%E7%9A%84id%E5%80%BC%E5%88%B0%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%E4%B8%AD%E8%AE%BF%E9%97%AE%E5%AE%8C%E6%95%B4%E7%9A%84%E7%94%A8%E6%88%B7%E8%AE%B0%E5%BD%95%E5%8F%AF%E8%83%BD%E5%88%86%E5%B8%83%E5%9C%A8%E4%B8%8D%E5%90%8C%E7%9A%84%E6%95%B0%E6%8D%AE%E9%A1%B5%E4%B8%AD%EF%BC%8C%E8%BF%99%E6%A0%B7%E8%AF%BB%E5%8F%96%E5%AE%8C%E6%95%B4%E7%9A%84%E7%94%A8%E6%88%B7%E8%AE%B0%E5%BD%95%E5%8F%AF%E8%83%BD%E8%A6%81%E8%AE%BF%E9%97%AE%E6%9B%B4%E5%A4%9A%E7%9A%84%E6%95%B0%E6%8D%AE%E9%A1%B5%EF%BC%8C%E8%BF%99%E7%A7%8D%E8%AF%BB%E5%8F%96%E6%96%B9%E5%BC%8F%E6%88%91%E4%BB%AC%E4%B9%9F%E5%8F%AF%E4%BB%A5%E7%A7%B0%E4%B8%BA**%E9%9A%8F%E6%9C%BAI%2FO**%E3%80%82%E4%B8%80%E8%88%AC%E6%83%85%E5%86%B5%E4%B8%8B%EF%BC%8C%E9%A1%BA%E5%BA%8FI%2FO%E6%AF%94%E9%9A%8F%E6%9C%BAI%2FO%E7%9A%84%E6%80%A7%E8%83%BD%E9%AB%98%E5%BE%88%E5%A4%9A%EF%BC%8C%E6%89%80%E4%BB%A5%E6%AD%A5%E9%AA%A41%E7%9A%84%E6%89%A7%E8%A1%8C%E5%8F%AF%E8%83%BD%E5%BE%88%E5%BF%AB%EF%BC%8C%E8%80%8C%E6%AD%A5%E9%AA%A42%E5%B0%B1%E6%85%A2%E4%B8%80%E4%BA%9B%E3%80%82%E6%89%80%E4%BB%A5%E8%BF%99%E4%B8%AA%E4%BD%BF%E7%94%A8%E7%B4%A2%E5%BC%95idx_name_birthday_phone_number%E7%9A%84%E6%9F%A5%E8%AF%A2%E6%9C%89%E8%BF%99%E4%B9%88%E4%B8%A4%E4%B8%AA%E7%89%B9%E7%82%B9%EF%BC%9A%0A%0A*%20**%E4%BC%9A%E4%BD%BF%E7%94%A8%E5%88%B0%E4%B8%A4%E4%B8%AAB%2B%E6%A0%91%E7%B4%A2%E5%BC%95%EF%BC%8C%E4%B8%80%E4%B8%AA%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%EF%BC%8C%E4%B8%80%E4%B8%AA%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%EF%BC%9B**%0A*%20**%E8%AE%BF%E9%97%AE%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%E4%BD%BF%E7%94%A8%E9%A1%BA%E5%BA%8FI%2FO%EF%BC%8C%E8%AE%BF%E9%97%AE%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%E4%BD%BF%E7%94%A8%E9%9A%8F%E6%9C%BAI%2FO%EF%BC%9B**%0A%0A%0A%E9%9C%80%E8%A6%81%E5%9B%9E%E8%A1%A8%E7%9A%84%E8%AE%B0%E5%BD%95%E8%B6%8A%E5%A4%9A%EF%BC%8C%E4%BD%BF%E7%94%A8%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%E7%9A%84%E6%80%A7%E8%83%BD%E5%B0%B1%E8%B6%8A%E4%BD%8E%EF%BC%8C%E7%94%9A%E8%87%B3%E8%AE%A9%E6%9F%90%E4%BA%9B%E6%9F%A5%E8%AF%A2%E5%AE%81%E6%84%BF%E4%BD%BF%E7%94%A8%E5%85%A8%E8%A1%A8%E6%89%AB%E6%8F%8F%E4%B9%9F%E4%B8%8D%E4%BD%BF%E7%94%A8%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%E3%80%82%E6%AF%94%E6%96%B9%E8%AF%B4name%E5%80%BC%E5%9C%A8Asa%EF%BD%9EBarlow%E4%B9%8B%E9%97%B4%E7%9A%84%E7%94%A8%E6%88%B7%E8%AE%B0%E5%BD%95%E6%95%B0%E9%87%8F%E5%8D%A0%E5%85%A8%E9%83%A8%E8%AE%B0%E5%BD%95%E6%95%B0%E9%87%8F90%25%E4%BB%A5%E4%B8%8A%EF%BC%8C%E9%82%A3%E4%B9%88%E5%A6%82%E6%9E%9C%E4%BD%BF%E7%94%A8idx_name_birthday_phone_number%E7%B4%A2%E5%BC%95%E7%9A%84%E8%AF%9D%EF%BC%8C%E6%9C%8990%25%E5%A4%9A%E7%9A%84id%E5%80%BC%E9%9C%80%E8%A6%81%E5%9B%9E%E8%A1%A8%EF%BC%8C%E8%BF%99%E4%B8%8D%E6%98%AF%E5%90%83%E5%8A%9B%E4%B8%8D%E8%AE%A8%E5%A5%BD%E4%B9%88%EF%BC%8C%E8%BF%98%E4%B8%8D%E5%A6%82%E7%9B%B4%E6%8E%A5%E5%8E%BB%E6%89%AB%E6%8F%8F%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%EF%BC%88%E4%B9%9F%E5%B0%B1%E6%98%AF%E5%85%A8%E8%A1%A8%E6%89%AB%E6%8F%8F%EF%BC%89%E3%80%82%E9%82%A3%E4%BB%80%E4%B9%88%E6%97%B6%E5%80%99%E9%87%87%E7%94%A8%E5%85%A8%E8%A1%A8%E6%89%AB%E6%8F%8F%E7%9A%84%E6%96%B9%E5%BC%8F%EF%BC%8C%E4%BB%80%E4%B9%88%E6%97%B6%E5%80%99%E4%BD%BF%E7%94%A8%E9%87%87%E7%94%A8%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%20%2B%20%E5%9B%9E%E8%A1%A8%E7%9A%84%E6%96%B9%E5%BC%8F%E5%8E%BB%E6%89%A7%E8%A1%8C%E6%9F%A5%E8%AF%A2%E5%91%A2%EF%BC%9F%E8%BF%99%E4%B8%AA%E5%B0%B1%E6%98%AF%E4%BC%A0%E8%AF%B4%E4%B8%AD%E7%9A%84%E6%9F%A5%E8%AF%A2%E4%BC%98%E5%8C%96%E5%99%A8%E5%81%9A%E7%9A%84%E5%B7%A5%E4%BD%9C%EF%BC%8C%E6%9F%A5%E8%AF%A2%E4%BC%98%E5%8C%96%E5%99%A8%E4%BC%9A%E4%BA%8B%E5%85%88%E5%AF%B9%E8%A1%A8%E4%B8%AD%E7%9A%84%E8%AE%B0%E5%BD%95%E8%AE%A1%E7%AE%97%E4%B8%80%E4%BA%9B%E7%BB%9F%E8%AE%A1%E6%95%B0%E6%8D%AE%EF%BC%8C%E7%84%B6%E5%90%8E%E5%86%8D%E5%88%A9%E7%94%A8%E8%BF%99%E4%BA%9B%E7%BB%9F%E8%AE%A1%E6%95%B0%E6%8D%AE%E6%A0%B9%E6%8D%AE%E6%9F%A5%E8%AF%A2%E7%9A%84%E6%9D%A1%E4%BB%B6%E6%9D%A5%E8%AE%A1%E7%AE%97%E4%B8%80%E4%B8%8B%E9%9C%80%E8%A6%81%E5%9B%9E%E8%A1%A8%E7%9A%84%E8%AE%B0%E5%BD%95%E6%95%B0%EF%BC%8C%E9%9C%80%E8%A6%81%E5%9B%9E%E8%A1%A8%E7%9A%84%E8%AE%B0%E5%BD%95%E6%95%B0%E8%B6%8A%E5%A4%9A%EF%BC%8C%E5%B0%B1%E8%B6%8A%E5%80%BE%E5%90%91%E4%BA%8E%E4%BD%BF%E7%94%A8%E5%85%A8%E8%A1%A8%E6%89%AB%E6%8F%8F%EF%BC%8C%E5%8F%8D%E4%B9%8B%E5%80%BE%E5%90%91%E4%BA%8E%E4%BD%BF%E7%94%A8%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%20%2B%20%E5%9B%9E%E8%A1%A8%E7%9A%84%E6%96%B9%E5%BC%8F%E3%80%82%E5%BD%93%E7%84%B6%E4%BC%98%E5%8C%96%E5%99%A8%E5%81%9A%E7%9A%84%E5%88%86%E6%9E%90%E5%B7%A5%E4%BD%9C%E4%B8%8D%E4%BB%85%E4%BB%85%E6%98%AF%E8%BF%99%E4%B9%88%E7%AE%80%E5%8D%95%EF%BC%8C%E4%BD%86%E6%98%AF%E5%A4%A7%E8%87%B4%E4%B8%8A%E6%98%AF%E4%B8%AA%E8%BF%99%E4%B8%AA%E8%BF%87%E7%A8%8B%E3%80%82%E4%B8%80%E8%88%AC%E6%83%85%E5%86%B5%E4%B8%8B%EF%BC%8C%E9%99%90%E5%88%B6%E6%9F%A5%E8%AF%A2%E8%8E%B7%E5%8F%96%E8%BE%83%E5%B0%91%E7%9A%84%E8%AE%B0%E5%BD%95%E6%95%B0%E4%BC%9A%E8%AE%A9%E4%BC%98%E5%8C%96%E5%99%A8%E6%9B%B4%E5%80%BE%E5%90%91%E4%BA%8E%E9%80%89%E6%8B%A9%E4%BD%BF%E7%94%A8%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%20%2B%20%E5%9B%9E%E8%A1%A8%E7%9A%84%E6%96%B9%E5%BC%8F%E8%BF%9B%E8%A1%8C%E6%9F%A5%E8%AF%A2%EF%BC%8C%E5%9B%A0%E4%B8%BA%E5%9B%9E%E8%A1%A8%E7%9A%84%E8%AE%B0%E5%BD%95%E8%B6%8A%E5%B0%91%EF%BC%8C%E6%80%A7%E8%83%BD%E6%8F%90%E5%8D%87%E5%B0%B1%E8%B6%8A%E9%AB%98%EF%BC%8C%E6%AF%94%E6%96%B9%E8%AF%B4%E4%B8%8A%E8%BE%B9%E7%9A%84%E6%9F%A5%E8%AF%A2%E5%8F%AF%E4%BB%A5%E6%94%B9%E5%86%99%E6%88%90%E8%BF%99%E6%A0%B7%EF%BC%9A%0A%0ASELECT%20*%20FROM%20person_info%20WHERE%20name%20%3E%20'Asa'%20AND%20name%20%3C%20'Barlow'%20LIMIT%2010%3B%0A%0A%E6%B7%BB%E5%8A%A0%E4%BA%86LIMIT%2010%E7%9A%84%E6%9F%A5%E8%AF%A2%E6%9B%B4%E5%AE%B9%E6%98%93%E8%AE%A9%E4%BC%98%E5%8C%96%E5%99%A8%E9%87%87%E7%94%A8%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%20%2B%20%E5%9B%9E%E8%A1%A8%E7%9A%84%E6%96%B9%E5%BC%8F%E8%BF%9B%E8%A1%8C%E6%9F%A5%E8%AF%A2%E3%80%82%E5%AF%B9%E4%BA%8E%E6%9C%89%E6%8E%92%E5%BA%8F%E9%9C%80%E6%B1%82%E7%9A%84%E6%9F%A5%E8%AF%A2%EF%BC%8C%E4%B8%8A%E8%BE%B9%E8%AE%A8%E8%AE%BA%E7%9A%84%E9%87%87%E7%94%A8%E5%85%A8%E8%A1%A8%E6%89%AB%E6%8F%8F%E8%BF%98%E6%98%AF%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%20%2B%20%E5%9B%9E%E8%A1%A8%E7%9A%84%E6%96%B9%E5%BC%8F%E8%BF%9B%E8%A1%8C%E6%9F%A5%E8%AF%A2%E7%9A%84%E6%9D%A1%E4%BB%B6%E4%B9%9F%E6%98%AF%E6%88%90%E7%AB%8B%E7%9A%84%E3%80%82%0A%0A%E7%94%B1%E4%BA%8E%E6%9F%A5%E8%AF%A2%E5%88%97%E8%A1%A8%E6%98%AF*%EF%BC%8C%E6%89%80%E4%BB%A5%E5%A6%82%E6%9E%9C%E4%BD%BF%E7%94%A8%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%E7%9A%84%E8%AF%9D%EF%BC%8C%E9%9C%80%E8%A6%81%E6%8A%8A%E6%8E%92%E5%BA%8F%E5%AE%8C%E7%9A%84%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%E8%AE%B0%E5%BD%95%E5%85%A8%E9%83%A8%E8%BF%9B%E8%A1%8C%E5%9B%9E%E8%A1%A8%E6%93%8D%E4%BD%9C%EF%BC%8C%E8%BF%99%E6%A0%B7%E6%93%8D%E4%BD%9C%E7%9A%84%E6%88%90%E6%9C%AC%E8%BF%98%E4%B8%8D%E5%A6%82%E7%9B%B4%E6%8E%A5%E9%81%8D%E5%8E%86%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%E7%84%B6%E5%90%8E%E5%86%8D%E8%BF%9B%E8%A1%8C%E6%96%87%E4%BB%B6%E6%8E%92%E5%BA%8F%EF%BC%88filesort%EF%BC%89%E4%BD%8E%EF%BC%8C%E6%89%80%E4%BB%A5%E4%BC%98%E5%8C%96%E5%99%A8%E4%BC%9A%E5%80%BE%E5%90%91%E4%BA%8E%E4%BD%BF%E7%94%A8%E5%85%A8%E8%A1%A8%E6%89%AB%E6%8F%8F%E7%9A%84%E6%96%B9%E5%BC%8F%E6%89%A7%E8%A1%8C%E6%9F%A5%E8%AF%A2%E3%80%82%E5%A6%82%E6%9E%9C%E6%88%91%E4%BB%AC%E5%8A%A0%E4%BA%86LIMIT%E5%AD%90%E5%8F%A5%EF%BC%8C%E6%AF%94%E5%A6%82%E8%BF%99%E6%A0%B7%EF%BC%9A%0ASELECT%20*%20FROM%20person_info%20ORDER%20BY%20name%2C%20birthday%2C%20phone_number%20LIMIT%2010%EF%BC%9B%0A%E8%BF%99%E6%A0%B7%E9%9C%80%E8%A6%81%E5%9B%9E%E8%A1%A8%E7%9A%84%E8%AE%B0%E5%BD%95%E7%89%B9%E5%88%AB%E5%B0%91%EF%BC%8C%E4%BC%98%E5%8C%96%E5%99%A8%E5%B0%B1%E4%BC%9A%E5%80%BE%E5%90%91%E4%BA%8E%E4%BD%BF%E7%94%A8%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%20%2B%20%E5%9B%9E%E8%A1%A8%E7%9A%84%E6%96%B9%E5%BC%8F%E6%89%A7%E8%A1%8C%E6%9F%A5%E8%AF%A2%E3%80%82%0A%0A%23%23%23%23%20%E8%A6%86%E7%9B%96%E7%B4%A2%E5%BC%95%0A%0A%E4%B8%BA%E4%BA%86%E5%BD%BB%E5%BA%95%E5%91%8A%E5%88%AB%E5%9B%9E%E8%A1%A8%E6%93%8D%E4%BD%9C%E5%B8%A6%E6%9D%A5%E7%9A%84%E6%80%A7%E8%83%BD%E6%8D%9F%E8%80%97%EF%BC%8C%E6%88%91%E4%BB%AC%E5%BB%BA%E8%AE%AE%EF%BC%9A%E6%9C%80%E5%A5%BD%E5%9C%A8%E6%9F%A5%E8%AF%A2%E5%88%97%E8%A1%A8%E9%87%8C%E5%8F%AA%E5%8C%85%E5%90%AB%E7%B4%A2%E5%BC%95%E5%88%97%EF%BC%8C%E6%AF%94%E5%A6%82%E8%BF%99%E6%A0%B7%EF%BC%9A%0A**SELECT%20name%2C%20birthday%2C%20phone_number%20FROM%20person_info%20WHERE%20name%20%3E%20'Asa'%20AND%20name%20%3C%20'Barlow'%EF%BC%9B**%0A%0A%E5%9B%A0%E4%B8%BA%E6%88%91%E4%BB%AC%E5%8F%AA%E6%9F%A5%E8%AF%A2name%2C%C2%A0birthday%2C%C2%A0phone_number%E8%BF%99%E4%B8%89%E4%B8%AA%E7%B4%A2%E5%BC%95%E5%88%97%E7%9A%84%E5%80%BC%EF%BC%8C%E6%89%80%E4%BB%A5%E5%9C%A8%E9%80%9A%E8%BF%87idx_name_birthday_phone_number%E7%B4%A2%E5%BC%95%E5%BE%97%E5%88%B0%E7%BB%93%E6%9E%9C%E5%90%8E%E5%B0%B1%E4%B8%8D%E5%BF%85%E5%88%B0%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%E4%B8%AD%E5%86%8D%E6%9F%A5%E6%89%BE%E8%AE%B0%E5%BD%95%E7%9A%84%E5%89%A9%E4%BD%99%E5%88%97%EF%BC%8C%E4%B9%9F%E5%B0%B1%E6%98%AFcountry%E5%88%97%E7%9A%84%E5%80%BC%E4%BA%86%EF%BC%8C%E8%BF%99%E6%A0%B7%E5%B0%B1%E7%9C%81%E5%8E%BB%E4%BA%86%E5%9B%9E%E8%A1%A8%E6%93%8D%E4%BD%9C%E5%B8%A6%E6%9D%A5%E7%9A%84%E6%80%A7%E8%83%BD%E6%8D%9F%E8%80%97%E3%80%82%E6%88%91%E4%BB%AC%E6%8A%8A%E8%BF%99%E7%A7%8D%E5%8F%AA%E9%9C%80%E8%A6%81%E7%94%A8%E5%88%B0%E7%B4%A2%E5%BC%95%E7%9A%84%E6%9F%A5%E8%AF%A2%E6%96%B9%E5%BC%8F%E7%A7%B0%E4%B8%BA%E7%B4%A2%E5%BC%95%E8%A6%86%E7%9B%96%E3%80%82%E6%8E%92%E5%BA%8F%E6%93%8D%E4%BD%9C%E4%B9%9F%E4%BC%98%E5%85%88%E4%BD%BF%E7%94%A8%E8%A6%86%E7%9B%96%E7%B4%A2%E5%BC%95%E7%9A%84%E6%96%B9%E5%BC%8F%E8%BF%9B%E8%A1%8C%E6%9F%A5%E8%AF%A2%EF%BC%8C%E6%AF%94%E6%96%B9%E8%AF%B4%E8%BF%99%E4%B8%AA%E6%9F%A5%E8%AF%A2%EF%BC%9A%0A**SELECT%20name%2C%20birthday%2C%20phone_number%20%20FROM%20person_info%20ORDER%20BY%20name%2C%20birthday%2C%20phone_number%EF%BC%9B**%0A%0A%E8%99%BD%E7%84%B6%E8%BF%99%E4%B8%AA%E6%9F%A5%E8%AF%A2%E4%B8%AD%E6%B2%A1%E6%9C%89LIMIT%E5%AD%90%E5%8F%A5%EF%BC%8C%E4%BD%86%E6%98%AF%E9%87%87%E7%94%A8%E4%BA%86%E8%A6%86%E7%9B%96%E7%B4%A2%E5%BC%95%EF%BC%8C%E6%89%80%E4%BB%A5%E6%9F%A5%E8%AF%A2%E4%BC%98%E5%8C%96%E5%99%A8%E5%B0%B1%E4%BC%9A%E7%9B%B4%E6%8E%A5%E4%BD%BF%E7%94%A8idx_name_birthday_phone_number%E7%B4%A2%E5%BC%95%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%E8%80%8C%E4%B8%8D%E9%9C%80%E8%A6%81%E5%9B%9E%E8%A1%A8%E6%93%8D%E4%BD%9C%E4%BA%86%E3%80%82%E5%BD%93%E7%84%B6%EF%BC%8C%E5%A6%82%E6%9E%9C%E4%B8%9A%E5%8A%A1%E9%9C%80%E8%A6%81%E6%9F%A5%E8%AF%A2%E5%87%BA%E7%B4%A2%E5%BC%95%E4%BB%A5%E5%A4%96%E7%9A%84%E5%88%97%EF%BC%8C%E9%82%A3%E8%BF%98%E6%98%AF%E4%BB%A5%E4%BF%9D%E8%AF%81%E4%B8%9A%E5%8A%A1%E9%9C%80%E6%B1%82%E4%B8%BA%E9%87%8D%E3%80%82%E4%BD%86%E6%98%AF%E6%88%91%E4%BB%AC%E5%BE%88%E4%B8%8D%E9%BC%93%E5%8A%B1%E7%94%A8*%E5%8F%B7%E4%BD%9C%E4%B8%BA%E6%9F%A5%E8%AF%A2%E5%88%97%E8%A1%A8%EF%BC%8C%E6%9C%80%E5%A5%BD%E6%8A%8A%E6%88%91%E4%BB%AC%E9%9C%80%E8%A6%81%E6%9F%A5%E8%AF%A2%E7%9A%84%E5%88%97%E4%BE%9D%E6%AC%A1%E6%A0%87%E6%98%8E%E3%80%82%0A%0A%23%23%204.%20%E5%A6%82%E4%BD%95%E6%8C%91%E9%80%89%E7%B4%A2%E5%BC%95%0A%0A%23%23%23%23%20%E5%8F%AA%E4%B8%BA%E7%94%A8%E4%BA%8E%E6%90%9C%E7%B4%A2%E3%80%81%E6%8E%92%E5%BA%8F%E6%88%96%E5%88%86%E7%BB%84%E7%9A%84%E5%88%97%E5%88%9B%E5%BB%BA%E7%B4%A2%E5%BC%95%0A%0A%E5%8F%AA%E4%B8%BA%E5%87%BA%E7%8E%B0%E5%9C%A8**WHERE%E5%AD%90%E5%8F%A5**%E4%B8%AD%E7%9A%84%E5%88%97%E3%80%81%E8%BF%9E%E6%8E%A5%E5%AD%90%E5%8F%A5%E4%B8%AD%E7%9A%84%E8%BF%9E%E6%8E%A5%E5%88%97%EF%BC%8C%E6%88%96%E8%80%85%E5%87%BA%E7%8E%B0%E5%9C%A8**ORDER%20BY**%E6%88%96**GROUP%20BY**%E5%AD%90%E5%8F%A5%E4%B8%AD%E7%9A%84%E5%88%97%E5%88%9B%E5%BB%BA%E7%B4%A2%E5%BC%95%E3%80%82%E8%80%8C%E5%87%BA%E7%8E%B0%E5%9C%A8%E6%9F%A5%E8%AF%A2%E5%88%97%E8%A1%A8%E4%B8%AD%E7%9A%84%E5%88%97%E5%B0%B1%E6%B2%A1%E5%BF%85%E8%A6%81%E5%BB%BA%E7%AB%8B%E7%B4%A2%E5%BC%95%E4%BA%86%0A%0A%23%23%23%23%20%E8%80%83%E8%99%91%E5%88%97%E7%9A%84%E5%9F%BA%E6%95%B0%0A%0A%E5%88%97%E7%9A%84%E5%9F%BA%E6%95%B0%E6%8C%87%E7%9A%84%E6%98%AF%E6%9F%90%E4%B8%80%E5%88%97%E4%B8%AD%E4%B8%8D%E9%87%8D%E5%A4%8D%E6%95%B0%E6%8D%AE%E7%9A%84%E4%B8%AA%E6%95%B0%EF%BC%8C%E6%AF%94%E6%96%B9%E8%AF%B4%E6%9F%90%E4%B8%AA%E5%88%97%E5%8C%85%E5%90%AB%E5%80%BC2%2C%205%2C%208%2C%202%2C%205%2C%208%2C%202%2C%205%2C%208%EF%BC%8C%E8%99%BD%E7%84%B6%E6%9C%899%E6%9D%A1%E8%AE%B0%E5%BD%95%EF%BC%8C%E4%BD%86%E8%AF%A5%E5%88%97%E7%9A%84%E5%9F%BA%E6%95%B0%E5%8D%B4%E6%98%AF3%E3%80%82%E4%B9%9F%E5%B0%B1%E6%98%AF%E8%AF%B4%EF%BC%8C%E5%9C%A8%E8%AE%B0%E5%BD%95%E8%A1%8C%E6%95%B0%E4%B8%80%E5%AE%9A%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%EF%BC%8C%E5%88%97%E7%9A%84%E5%9F%BA%E6%95%B0%E8%B6%8A%E5%A4%A7%EF%BC%8C%E8%AF%A5%E5%88%97%E4%B8%AD%E7%9A%84%E5%80%BC%E8%B6%8A%E5%88%86%E6%95%A3%EF%BC%8C%E5%88%97%E7%9A%84%E5%9F%BA%E6%95%B0%E8%B6%8A%E5%B0%8F%EF%BC%8C%E8%AF%A5%E5%88%97%E4%B8%AD%E7%9A%84%E5%80%BC%E8%B6%8A%E9%9B%86%E4%B8%AD%E3%80%82%E8%BF%99%E4%B8%AA%E5%88%97%E7%9A%84%E5%9F%BA%E6%95%B0%E6%8C%87%E6%A0%87%E9%9D%9E%E5%B8%B8%E9%87%8D%E8%A6%81%EF%BC%8C%E7%9B%B4%E6%8E%A5%E5%BD%B1%E5%93%8D%E6%88%91%E4%BB%AC%E6%98%AF%E5%90%A6%E8%83%BD%E6%9C%89%E6%95%88%E7%9A%84%E5%88%A9%E7%94%A8%E7%B4%A2%E5%BC%95%E3%80%82%E5%81%87%E8%AE%BE%E6%9F%90%E4%B8%AA%E5%88%97%E7%9A%84%E5%9F%BA%E6%95%B0%E4%B8%BA1%EF%BC%8C%E4%B9%9F%E5%B0%B1%E6%98%AF%E6%89%80%E6%9C%89%E8%AE%B0%E5%BD%95%E5%9C%A8%E8%AF%A5%E5%88%97%E4%B8%AD%E7%9A%84%E5%80%BC%E9%83%BD%E4%B8%80%E6%A0%B7%EF%BC%8C%E9%82%A3%E4%B8%BA%E8%AF%A5%E5%88%97%E5%BB%BA%E7%AB%8B%E7%B4%A2%E5%BC%95%E6%98%AF%E6%B2%A1%E6%9C%89%E7%94%A8%E7%9A%84%EF%BC%8C%E5%9B%A0%E4%B8%BA%E6%89%80%E6%9C%89%E5%80%BC%E9%83%BD%E4%B8%80%E6%A0%B7%E5%B0%B1%E6%97%A0%E6%B3%95%E6%8E%92%E5%BA%8F%EF%BC%8C%E6%97%A0%E6%B3%95%E8%BF%9B%E8%A1%8C%E5%BF%AB%E9%80%9F%E6%9F%A5%E6%89%BE%E4%BA%86%EF%BD%9E%20%E8%80%8C%E4%B8%94%E5%A6%82%E6%9E%9C%E6%9F%90%E4%B8%AA%E5%BB%BA%E7%AB%8B%E4%BA%86%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%E7%9A%84%E5%88%97%E7%9A%84%E9%87%8D%E5%A4%8D%E5%80%BC%E7%89%B9%E5%88%AB%E5%A4%9A%EF%BC%8C%E9%82%A3%E4%B9%88%E4%BD%BF%E7%94%A8%E8%BF%99%E4%B8%AA%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%E6%9F%A5%E5%87%BA%E7%9A%84%E8%AE%B0%E5%BD%95%E8%BF%98%E5%8F%AF%E8%83%BD%E8%A6%81%E5%81%9A%E5%9B%9E%E8%A1%A8%E6%93%8D%E4%BD%9C%EF%BC%8C%E8%BF%99%E6%A0%B7%E6%80%A7%E8%83%BD%E6%8D%9F%E8%80%97%E5%B0%B1%E6%9B%B4%E5%A4%A7%E4%BA%86%E3%80%82%E6%89%80%E4%BB%A5%E7%BB%93%E8%AE%BA%E5%B0%B1%E6%98%AF%EF%BC%9A%E6%9C%80%E5%A5%BD%E4%B8%BA%E9%82%A3%E4%BA%9B%E5%88%97%E7%9A%84%E5%9F%BA%E6%95%B0%E5%A4%A7%E7%9A%84%E5%88%97%E5%BB%BA%E7%AB%8B%E7%B4%A2%E5%BC%95%EF%BC%8C%E4%B8%BA%E5%9F%BA%E6%95%B0%E5%A4%AA%E5%B0%8F%E5%88%97%E7%9A%84%E5%BB%BA%E7%AB%8B%E7%B4%A2%E5%BC%95%E6%95%88%E6%9E%9C%E5%8F%AF%E8%83%BD%E4%B8%8D%E5%A5%BD%E3%80%82%0A%0A%23%23%23%23%20%E7%B4%A2%E5%BC%95%E5%88%97%E7%9A%84%E7%B1%BB%E5%9E%8B%E5%B0%BD%E9%87%8F%E5%B0%8F%0A%0A%E6%88%91%E4%BB%AC%E5%9C%A8%E5%AE%9A%E4%B9%89%E8%A1%A8%E7%BB%93%E6%9E%84%E7%9A%84%E6%97%B6%E5%80%99%E8%A6%81%E6%98%BE%E5%BC%8F%E7%9A%84%E6%8C%87%E5%AE%9A%E5%88%97%E7%9A%84%E7%B1%BB%E5%9E%8B%EF%BC%8C%E4%BB%A5%E6%95%B4%E6%95%B0%E7%B1%BB%E5%9E%8B%E4%B8%BA%E4%BE%8B%EF%BC%8C%E6%9C%89TINYINT%E3%80%81MEDIUMINT%E3%80%81INT%E3%80%81BIGINT%E8%BF%99%E4%B9%88%E5%87%A0%E7%A7%8D%EF%BC%8C%E5%AE%83%E4%BB%AC%E5%8D%A0%E7%94%A8%E7%9A%84%E5%AD%98%E5%82%A8%E7%A9%BA%E9%97%B4%E4%BE%9D%E6%AC%A1%E9%80%92%E5%A2%9E%EF%BC%8C%E6%88%91%E4%BB%AC%E8%BF%99%E9%87%8C%E6%89%80%E8%AF%B4%E7%9A%84%E7%B1%BB%E5%9E%8B%E5%A4%A7%E5%B0%8F%E6%8C%87%E7%9A%84%E5%B0%B1%E6%98%AF%E8%AF%A5%E7%B1%BB%E5%9E%8B%E8%A1%A8%E7%A4%BA%E7%9A%84%E6%95%B0%E6%8D%AE%E8%8C%83%E5%9B%B4%E7%9A%84%E5%A4%A7%E5%B0%8F%E3%80%82%E8%83%BD%E8%A1%A8%E7%A4%BA%E7%9A%84%E6%95%B4%E6%95%B0%E8%8C%83%E5%9B%B4%E5%BD%93%E7%84%B6%E4%B9%9F%E6%98%AF%E4%BE%9D%E6%AC%A1%E9%80%92%E5%A2%9E%EF%BC%8C%E5%A6%82%E6%9E%9C%E6%88%91%E4%BB%AC%E6%83%B3%E8%A6%81%E5%AF%B9%E6%9F%90%E4%B8%AA%E6%95%B4%E6%95%B0%E5%88%97%E5%BB%BA%E7%AB%8B%E7%B4%A2%E5%BC%95%E7%9A%84%E8%AF%9D%EF%BC%8C**%E5%9C%A8%E8%A1%A8%E7%A4%BA%E7%9A%84%E6%95%B4%E6%95%B0%E8%8C%83%E5%9B%B4%E5%85%81%E8%AE%B8%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%EF%BC%8C%E5%B0%BD%E9%87%8F%E8%AE%A9%E7%B4%A2%E5%BC%95%E5%88%97%E4%BD%BF%E7%94%A8%E8%BE%83%E5%B0%8F%E7%9A%84%E7%B1%BB%E5%9E%8B**%EF%BC%8C%E6%AF%94%E5%A6%82%E6%88%91%E4%BB%AC%E8%83%BD%E4%BD%BF%E7%94%A8INT%E5%B0%B1%E4%B8%8D%E8%A6%81%E4%BD%BF%E7%94%A8BIGINT%EF%BC%8C%E8%83%BD%E4%BD%BF%E7%94%A8MEDIUMINT%E5%B0%B1%E4%B8%8D%E8%A6%81%E4%BD%BF%E7%94%A8INT%EF%BD%9E%20%E8%BF%99%E6%98%AF%E5%9B%A0%E4%B8%BA%EF%BC%9A%0A%0A*%20%E6%95%B0%E6%8D%AE%E7%B1%BB%E5%9E%8B%E8%B6%8A%E5%B0%8F%EF%BC%8C%E5%9C%A8%E6%9F%A5%E8%AF%A2%E6%97%B6%E8%BF%9B%E8%A1%8C%E7%9A%84%E6%AF%94%E8%BE%83%E6%93%8D%E4%BD%9C%E8%B6%8A%E5%BF%AB%EF%BC%88%E8%BF%99%E6%98%AFCPU%E5%B1%82%E6%AC%A1%E7%9A%84%E4%B8%9C%E4%B8%9C%EF%BC%89%EF%BC%9B%0A*%20%E6%95%B0%E6%8D%AE%E7%B1%BB%E5%9E%8B%E8%B6%8A%E5%B0%8F%EF%BC%8C%E7%B4%A2%E5%BC%95%E5%8D%A0%E7%94%A8%E7%9A%84%E5%AD%98%E5%82%A8%E7%A9%BA%E9%97%B4%E5%B0%B1%E8%B6%8A%E5%B0%91%EF%BC%8C%E5%9C%A8%E4%B8%80%E4%B8%AA%E6%95%B0%E6%8D%AE%E9%A1%B5%E5%86%85%E5%B0%B1%E5%8F%AF%E4%BB%A5%E6%94%BE%E4%B8%8B%E6%9B%B4%E5%A4%9A%E7%9A%84%E8%AE%B0%E5%BD%95%EF%BC%8C%E4%BB%8E%E8%80%8C%E5%87%8F%E5%B0%91%E7%A3%81%E7%9B%98I%2FO%E5%B8%A6%E6%9D%A5%E7%9A%84%E6%80%A7%E8%83%BD%E6%8D%9F%E8%80%97%EF%BC%8C%E4%B9%9F%E5%B0%B1%E6%84%8F%E5%91%B3%E7%9D%80%E5%8F%AF%E4%BB%A5%E6%8A%8A%E6%9B%B4%E5%A4%9A%E7%9A%84%E6%95%B0%E6%8D%AE%E9%A1%B5%E7%BC%93%E5%AD%98%E5%9C%A8%E5%86%85%E5%AD%98%E4%B8%AD%EF%BC%8C%E4%BB%8E%E8%80%8C%E5%8A%A0%E5%BF%AB%E8%AF%BB%E5%86%99%E6%95%88%E7%8E%87%EF%BC%9B%0A%0A%E8%BF%99%E4%B8%AA%E5%BB%BA%E8%AE%AE%E5%AF%B9%E4%BA%8E%E8%A1%A8%E7%9A%84%E4%B8%BB%E9%94%AE%E6%9D%A5%E8%AF%B4%E6%9B%B4%E5%8A%A0%E9%80%82%E7%94%A8%EF%BC%8C%E5%9B%A0%E4%B8%BA%E4%B8%8D%E4%BB%85%E6%98%AF%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%E4%B8%AD%E4%BC%9A%E5%AD%98%E5%82%A8%E4%B8%BB%E9%94%AE%E5%80%BC%EF%BC%8C%E5%85%B6%E4%BB%96%E6%89%80%E6%9C%89%E7%9A%84%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%E7%9A%84%E8%8A%82%E7%82%B9%E5%A4%84%E9%83%BD%E4%BC%9A%E5%AD%98%E5%82%A8%E4%B8%80%E4%BB%BD%E8%AE%B0%E5%BD%95%E7%9A%84%E4%B8%BB%E9%94%AE%E5%80%BC%EF%BC%8C%E5%A6%82%E6%9E%9C%E4%B8%BB%E9%94%AE%E9%80%82%E7%94%A8%E6%9B%B4%E5%B0%8F%E7%9A%84%E6%95%B0%E6%8D%AE%E7%B1%BB%E5%9E%8B%EF%BC%8C%E4%B9%9F%E5%B0%B1%E6%84%8F%E5%91%B3%E7%9D%80%E8%8A%82%E7%9C%81%E6%9B%B4%E5%A4%9A%E7%9A%84%E5%AD%98%E5%82%A8%E7%A9%BA%E9%97%B4%E5%92%8C%E6%9B%B4%E9%AB%98%E6%95%88%E7%9A%84I%2FO%E3%80%82%0A%0A%23%23%23%23%20%E7%B4%A2%E5%BC%95%E5%AD%97%E7%AC%A6%E4%B8%B2%E5%80%BC%E7%9A%84%E5%89%8D%E7%BC%80%0A%0A%E5%8F%AA%E5%AF%B9%E5%AD%97%E7%AC%A6%E4%B8%B2%E7%9A%84%E5%89%8D%E5%87%A0%E4%B8%AA%E5%AD%97%E7%AC%A6%E8%BF%9B%E8%A1%8C%E7%B4%A2%E5%BC%95%E4%B9%9F%E5%B0%B1%E6%98%AF%E8%AF%B4%E5%9C%A8%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%E7%9A%84%E8%AE%B0%E5%BD%95%E4%B8%AD%E5%8F%AA%E4%BF%9D%E7%95%99%E5%AD%97%E7%AC%A6%E4%B8%B2%E5%89%8D%E5%87%A0%E4%B8%AA%E5%AD%97%E7%AC%A6%E3%80%82%E8%BF%99%E6%A0%B7%E5%9C%A8%E6%9F%A5%E6%89%BE%E8%AE%B0%E5%BD%95%E6%97%B6%E8%99%BD%E7%84%B6%E4%B8%8D%E8%83%BD%E7%B2%BE%E7%A1%AE%E7%9A%84%E5%AE%9A%E4%BD%8D%E5%88%B0%E8%AE%B0%E5%BD%95%E7%9A%84%E4%BD%8D%E7%BD%AE%EF%BC%8C%E4%BD%86%E6%98%AF%E8%83%BD%E5%AE%9A%E4%BD%8D%E5%88%B0%E7%9B%B8%E5%BA%94%E5%89%8D%E7%BC%80%E6%89%80%E5%9C%A8%E7%9A%84%E4%BD%8D%E7%BD%AE%EF%BC%8C%E7%84%B6%E5%90%8E%E6%A0%B9%E6%8D%AE%E5%89%8D%E7%BC%80%E7%9B%B8%E5%90%8C%E7%9A%84%E8%AE%B0%E5%BD%95%E7%9A%84%E4%B8%BB%E9%94%AE%E5%80%BC%E5%9B%9E%E8%A1%A8%E6%9F%A5%E8%AF%A2%E5%AE%8C%E6%95%B4%E7%9A%84%E5%AD%97%E7%AC%A6%E4%B8%B2%E5%80%BC%EF%BC%8C%E5%86%8D%E5%AF%B9%E6%AF%94%E5%B0%B1%E5%A5%BD%E4%BA%86%E3%80%82%E8%BF%99%E6%A0%B7%E5%8F%AA%E5%9C%A8B%2B%E6%A0%91%E4%B8%AD%E5%AD%98%E5%82%A8%E5%AD%97%E7%AC%A6%E4%B8%B2%E7%9A%84%E5%89%8D%E5%87%A0%E4%B8%AA%E5%AD%97%E7%AC%A6%E7%9A%84%E7%BC%96%E7%A0%81%EF%BC%8C%E6%97%A2%E8%8A%82%E7%BA%A6%E7%A9%BA%E9%97%B4%EF%BC%8C%E5%8F%88%E5%87%8F%E5%B0%91%E4%BA%86%E5%AD%97%E7%AC%A6%E4%B8%B2%E7%9A%84%E6%AF%94%E8%BE%83%E6%97%B6%E9%97%B4%EF%BC%8C%E8%BF%98%E5%A4%A7%E6%A6%82%E8%83%BD%E8%A7%A3%E5%86%B3%E6%8E%92%E5%BA%8F%E7%9A%84%E9%97%AE%E9%A2%98%EF%BC%8C%E4%BD%95%E4%B9%90%E8%80%8C%E4%B8%8D%E4%B8%BA%EF%BC%8C%E6%AF%94%E6%96%B9%E8%AF%B4%E6%88%91%E4%BB%AC%E5%9C%A8%E5%BB%BA%E8%A1%A8%E8%AF%AD%E5%8F%A5%E4%B8%AD%E5%8F%AA%E5%AF%B9name%E5%88%97%E7%9A%84%E5%89%8D10%E4%B8%AA%E5%AD%97%E7%AC%A6%E8%BF%9B%E8%A1%8C%E7%B4%A2%E5%BC%95%E5%8F%AF%E4%BB%A5%E8%BF%99%E4%B9%88%E5%86%99%EF%BC%9A%0A%0ACREATE%20TABLE%20person_info(%20%0A%20%20%20%20name%20VARCHAR(100)%20NOT%20NULL%2C%20%0A%20%20%20%20birthday%20DATE%20NOT%20NULL%2C%20%0A%20%20%20%20phone_number%20CHAR(11)%20NOT%20NULL%2C%20%0A%20%20%20%20country%20varchar(100)%20NOT%20NULL%2C%20%0A%20%20%20%20**KEY%20idx_name_birthday_phone_number%20(name(10)%2C%20birthday%2C%20phone_number)**%20%0A%20)%3B%0A%20%0Aname(10)%E5%B0%B1%E8%A1%A8%E7%A4%BA%E5%9C%A8%E5%BB%BA%E7%AB%8B%E7%9A%84B%2B%E6%A0%91%E7%B4%A2%E5%BC%95%E4%B8%AD%E5%8F%AA%E4%BF%9D%E7%95%99%E8%AE%B0%E5%BD%95%E7%9A%84%E5%89%8D10%E4%B8%AA%E5%AD%97%E7%AC%A6%E7%9A%84%E7%BC%96%E7%A0%81%EF%BC%8C%E8%BF%99%E7%A7%8D%E5%8F%AA**%E7%B4%A2%E5%BC%95%E5%AD%97%E7%AC%A6%E4%B8%B2%E5%80%BC%E7%9A%84%E5%89%8D%E7%BC%80%E7%9A%84%E7%AD%96%E7%95%A5%E6%98%AF%E6%88%91%E4%BB%AC%E9%9D%9E%E5%B8%B8%E9%BC%93%E5%8A%B1%E7%9A%84%EF%BC%8C%E5%B0%A4%E5%85%B6%E6%98%AF%E5%9C%A8%E5%AD%97%E7%AC%A6%E4%B8%B2%E7%B1%BB%E5%9E%8B%E8%83%BD%E5%AD%98%E5%82%A8%E7%9A%84%E5%AD%97%E7%AC%A6%E6%AF%94%E8%BE%83%E5%A4%9A%E7%9A%84%E6%97%B6%E5%80%99**%E3%80%82%0A%0A%23%23%23%23%20%E7%B4%A2%E5%BC%95%E5%88%97%E5%89%8D%E7%BC%80%E5%AF%B9%E6%8E%92%E5%BA%8F%E7%9A%84%E5%BD%B1%E5%93%8D%0A%0A%E5%A6%82%E6%9E%9C%E4%BD%BF%E7%94%A8%E4%BA%86%E7%B4%A2%E5%BC%95%E5%88%97%E5%89%8D%E7%BC%80%EF%BC%8C%E6%AF%94%E6%96%B9%E8%AF%B4%E5%89%8D%E8%BE%B9%E5%8F%AA%E6%8A%8Aname%E5%88%97%E7%9A%84%E5%89%8D10%E4%B8%AA%E5%AD%97%E7%AC%A6%E6%94%BE%E5%88%B0%E4%BA%86%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%E4%B8%AD%EF%BC%8C%E4%B8%8B%E8%BE%B9%E8%BF%99%E4%B8%AA%E6%9F%A5%E8%AF%A2%E5%8F%AF%E8%83%BD%E5%B0%B1%E6%9C%89%E7%82%B9%E5%84%BF%E5%B0%B4%E5%B0%AC%E4%BA%86%EF%BC%9A%0A%0ASELECT%20*%20FROM%20person_info%20ORDER%20BY%20name%20LIMIT%2010%3B%0A%0A%E5%9B%A0%E4%B8%BA%E4%BA%8C%E7%BA%A7%E7%B4%A2%E5%BC%95%E4%B8%AD%E4%B8%8D%E5%8C%85%E5%90%AB%E5%AE%8C%E6%95%B4%E7%9A%84name%E5%88%97%E4%BF%A1%E6%81%AF%EF%BC%8C%E6%89%80%E4%BB%A5%E6%97%A0%E6%B3%95%E5%AF%B9%E5%89%8D%E5%8D%81%E4%B8%AA%E5%AD%97%E7%AC%A6%E7%9B%B8%E5%90%8C%EF%BC%8C%E5%90%8E%E8%BE%B9%E7%9A%84%E5%AD%97%E7%AC%A6%E4%B8%8D%E5%90%8C%E7%9A%84%E8%AE%B0%E5%BD%95%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%EF%BC%8C%E4%B9%9F%E5%B0%B1%E6%98%AF%E4%BD%BF%E7%94%A8%E7%B4%A2%E5%BC%95%E5%88%97%E5%89%8D%E7%BC%80%E7%9A%84%E6%96%B9%E5%BC%8F%E6%97%A0%E6%B3%95%E6%94%AF%E6%8C%81%E4%BD%BF%E7%94%A8%E7%B4%A2%E5%BC%95%E6%8E%92%E5%BA%8F%EF%BC%8C%E5%8F%AA%E5%A5%BD%E4%B9%96%E4%B9%96%E7%9A%84%E7%94%A8%E6%96%87%E4%BB%B6%E6%8E%92%E5%BA%8F%E5%96%BD%E3%80%82%0A%0A%0A%23%23%23%23%20%E8%AE%A9%E7%B4%A2%E5%BC%95%E5%88%97%E5%9C%A8%E6%AF%94%E8%BE%83%E8%A1%A8%E8%BE%BE%E5%BC%8F%E4%B8%AD%E5%8D%95%E7%8B%AC%E5%87%BA%E7%8E%B0%0A%0A%E5%81%87%E8%AE%BE%E8%A1%A8%E4%B8%AD%E6%9C%89%E4%B8%80%E4%B8%AA%E6%95%B4%E6%95%B0%E5%88%97my_col%EF%BC%8C%E6%88%91%E4%BB%AC%E4%B8%BA%E8%BF%99%E4%B8%AA%E5%88%97%E5%BB%BA%E7%AB%8B%E4%BA%86%E7%B4%A2%E5%BC%95%E3%80%82%E4%B8%8B%E8%BE%B9%E7%9A%84%E4%B8%A4%E4%B8%AAWHERE%E5%AD%90%E5%8F%A5%E8%99%BD%E7%84%B6%E8%AF%AD%E4%B9%89%E6%98%AF%E4%B8%80%E8%87%B4%E7%9A%84%EF%BC%8C%E4%BD%86%E6%98%AF%E5%9C%A8%E6%95%88%E7%8E%87%E4%B8%8A%E5%8D%B4%E6%9C%89%E5%B7%AE%E5%88%AB%EF%BC%9A%0A1.%20WHERE%20my_col%20*%202%20%3C%204%EF%BC%9B%0A2.%20WHERE%20my_col%20%3C%204%2F2%EF%BC%9B%0A%0A%E7%AC%AC1%E4%B8%AAWHERE%E5%AD%90%E5%8F%A5%E4%B8%ADmy_col%E5%88%97%E5%B9%B6%E4%B8%8D%E6%98%AF%E4%BB%A5%E5%8D%95%E7%8B%AC%E5%88%97%E7%9A%84%E5%BD%A2%E5%BC%8F%E5%87%BA%E7%8E%B0%E7%9A%84%EF%BC%8C%E8%80%8C%E6%98%AF%E4%BB%A5my_col%20*%202%E8%BF%99%E6%A0%B7%E7%9A%84%E8%A1%A8%E8%BE%BE%E5%BC%8F%E7%9A%84%E5%BD%A2%E5%BC%8F%E5%87%BA%E7%8E%B0%E7%9A%84%EF%BC%8C%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E4%BC%9A%E4%BE%9D%E6%AC%A1%E9%81%8D%E5%8E%86%E6%89%80%E6%9C%89%E7%9A%84%E8%AE%B0%E5%BD%95%EF%BC%8C%E8%AE%A1%E7%AE%97%E8%BF%99%E4%B8%AA%E8%A1%A8%E8%BE%BE%E5%BC%8F%E7%9A%84%E5%80%BC%E6%98%AF%E4%B8%8D%E6%98%AF%E5%B0%8F%E4%BA%8E4%EF%BC%8C%E6%89%80%E4%BB%A5%E8%BF%99%E7%A7%8D%E6%83%85%E5%86%B5%E4%B8%8B%E6%98%AF%E4%BD%BF%E7%94%A8%E4%B8%8D%E5%88%B0%E4%B8%BAmy_col%E5%88%97%E5%BB%BA%E7%AB%8B%E7%9A%84B%2B%E6%A0%91%E7%B4%A2%E5%BC%95%E7%9A%84%E3%80%82%E8%80%8C%E7%AC%AC2%E4%B8%AAWHERE%E5%AD%90%E5%8F%A5%E4%B8%ADmy_col%E5%88%97%E5%B9%B6%E6%98%AF%E4%BB%A5%E5%8D%95%E7%8B%AC%E5%88%97%E7%9A%84%E5%BD%A2%E5%BC%8F%E5%87%BA%E7%8E%B0%E7%9A%84%EF%BC%8C%E8%BF%99%E6%A0%B7%E7%9A%84%E6%83%85%E5%86%B5%E5%8F%AF%E4%BB%A5%E7%9B%B4%E6%8E%A5%E4%BD%BF%E7%94%A8B%2B%E6%A0%91%E7%B4%A2%E5%BC%95%E3%80%82%0A%0A%E6%89%80%E4%BB%A5%E7%BB%93%E8%AE%BA%E5%B0%B1%E6%98%AF%EF%BC%9A**%E5%A6%82%E6%9E%9C%E7%B4%A2%E5%BC%95%E5%88%97%E5%9C%A8%E6%AF%94%E8%BE%83%E8%A1%A8%E8%BE%BE%E5%BC%8F%E4%B8%AD%E4%B8%8D%E6%98%AF%E4%BB%A5%E5%8D%95%E7%8B%AC%E5%88%97%E7%9A%84%E5%BD%A2%E5%BC%8F%E5%87%BA%E7%8E%B0%EF%BC%8C%E8%80%8C%E6%98%AF%E4%BB%A5%E6%9F%90%E4%B8%AA%E8%A1%A8%E8%BE%BE%E5%BC%8F%EF%BC%8C%E6%88%96%E8%80%85%E5%87%BD%E6%95%B0%E8%B0%83%E7%94%A8%E5%BD%A2%E5%BC%8F%E5%87%BA%E7%8E%B0%E7%9A%84%E8%AF%9D%EF%BC%8C%E6%98%AF%E7%94%A8%E4%B8%8D%E5%88%B0%E7%B4%A2%E5%BC%95%E7%9A%84**%E3%80%82%0A%0A!%5B92ef0261f97dafb904f0d16e57554aec.jpeg%5D(en-resource%3A%2F%2Fdatabase%2F681%3A1)%0A%0A</center></span>
</div></body></html> 